Re: for libpq which include defines the type oids - Mailing list pgsql-general

From Pavel Stehule
Subject Re: for libpq which include defines the type oids
Date
Msg-id 162867790711052333t4bde0b20r97b8e48969760b19@mail.gmail.com
Whole thread Raw
In response to for libpq which include defines the type oids  (Samantha Atkins <sjatkins@mac.com>)
List pgsql-general
On 06/11/2007, Samantha Atkins <sjatkins@mac.com> wrote:
> I am probably overlooking something but where exactly are these found
> for inclusion is libpq based programs? Poking around my installation
> doesn't make it obvious.
>
> - samantha
>
>

Get oids dynamically. Use static oids on client part isn't good idea.
They can by changed and than you have to recompile your application.,

postgres=# select 'integer'::regtype::int;
 int4
------
   23
(1 row)

Regards
Pavel Stehule

pgsql-general by date:

Previous
From: Samantha Atkins
Date:
Subject: for libpq which include defines the type oids
Next
From: rihad
Date:
Subject: any way for ORDER BY x to imply NULLS FIRST in 8.3?