Skip site navigation (1) Skip section navigation (2)

PQftype() and Oid

From: Andro <andromede(at)gmail(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: PQftype() and Oid
Date: 2006-08-04 14:38:20
Message-ID: da7021e0608040738l3b0880a1q5a76b838937f8c78@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
Hi,

Oids are in pg_type catalog (server side) and src/include/catalog/pg_type.h
(hard-wired).

But what should we compare the Oid returned by PQftype() with?
Let's say I want to check if column 1 is a VARCHAR, do I have to

if (PQftype(res,1) == 1043)
 ...;

?
Isn't there a kind of enum which we could rely on to find out types? What if
Oids change in pg_type.h?

Thanks

Charles

Responses

pgsql-interfaces by date

Next:From: Volkan YAZICIDate: 2006-08-05 07:14:26
Subject: Re: PQftype() and Oid
Previous:From: andy rostDate: 2006-08-02 18:07:34
Subject: Re: Using FETCH ALL with descriptor areas

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group