From: Volkan YAZICI <yazicivo@ttnet.net.tr>
To: Andro <andromede@gmail.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: PQftype() and Oid
Date: Sat, 5 Aug 2006 10:14:26 +0300
Message-ID: <20060805071426.GA1404@alamut.tdm.local> (raw)
In-Reply-To: <da7021e0608040738l3b0880a1q5a76b838937f8c78@mail.gmail.com>
References: <da7021e0608040738l3b0880a1q5a76b838937f8c78@mail.gmail.com>
On Aug 04 04:38, Andro wrote:
> 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?
You can make another query on pg_type to learn OID of a specific type.
And then compare it with the returned one from PQftype(main_query_res).
Furthermore, I think this is the only reliable way of accomplising this
task. (IIRC, PHP PostgreSQL API does same too.) Otherwise, when you use
hard-wired headers (e.g. by including pg_type.h) what will you do when
related server has a custom type that isn't get shippied with the
PostgreSQL headers you included.
Regards.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: yazicivo@ttnet.net.tr, andromede@gmail.com
Subject: Re: PQftype() and Oid
In-Reply-To: <20060805071426.GA1404@alamut.tdm.local>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox