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