Re: Basic questions about PQprepare()

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Joachim Wieland <joe(at)mcknight(dot)de>
Cc: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Basic questions about PQprepare()
Date: 2006-01-30 03:00:34
Message-ID: 20060130030034.GA55649@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Jan 29, 2006 at 06:03:41PM +0100, Joachim Wieland wrote:
> On Sat, Jan 28, 2006 at 08:26:01PM +0100, Alexander Farber wrote:
> > Could you explain a bit more, where to get the OIDs?
>
> They are in the pg_type table, it is described here:
>
> http://www.postgresql.org/docs/8.1/static/catalog-pg-type.html

For standard types you could include server/catalog/pg_type.h and
use TEXTOID, INT4OID, etc. But as Tom Lane mentioned, if the query
is written so the backend can infer the types then you don't need
to bother.

--
Michael Fuhr

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Browne 2006-01-30 03:33:39 Re: Indexes
Previous Message Karsten Hilbert 2006-01-29 20:30:00 Re: creating users per database