Pavel Golub <pa...@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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to