Pavel Golub <pavel@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,
"SELECTfailed: %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
