PQftype implementation
in [PgSql]
|
Prev: pgsql: Make standby server continuouslyretry restoring the next WAL
Next: [HACKERS] Order of pg_stat_activity timestamp columns
From: Tom Lane on 17 Mar 2010 11:46 Pavel Golub <pavel(a)microolap.com> writes: > Here I created user-defined type "my_varchar" for internal tests. But > PQftype returns 1043 (varchar oid) for the "info" column. Really? I tried it and got 172069, which is about right for where the OID counter is in my database. I think you messed up your test. res = PQexec(conn, "select * from my_varchar_test"); if (PQresultStatus(res) != PGRES_TUPLES_OK) { fprintf(stderr, "SELECT failed: %s", PQerrorMessage(conn)); PQclear(res); exit_nicely(conn); } nFields = PQnfields(res); for (i = 0; i < nFields; i++) printf("%-15s %d\n", PQfname(res, i), PQftype(res, i)); regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Pavel Golub on 18 Mar 2010 04:07
Hello, Tom. Yes, you are absolutely right. My bad! Sorry guys! :) You wrote: TL> Pavel Golub <pavel(a)microolap.com> writes: >> Here I created user-defined type "my_varchar" for internal tests. But >> PQftype returns 1043 (varchar oid) for the "info" column. TL> Really? I tried it and got 172069, which is about right for where the TL> OID counter is in my database. I think you messed up your test. TL> res = PQexec(conn, "select * from my_varchar_test"); TL> if (PQresultStatus(res) != PGRES_TUPLES_OK) TL> { TL> fprintf(stderr, "SELECT failed: %s", PQerrorMessage(conn)); TL> PQclear(res); TL> exit_nicely(conn); TL> } TL> nFields = PQnfields(res); TL> for (i = 0; i < nFields; i++) TL> printf("%-15s %d\n", PQfname(res, i), PQftype(res, i)); TL> regards, tom lane -- With best wishes, Pavel mailto:pavel(a)gf.microolap.com -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers |