On 22 February 2012 18:00, Andrew Dunstan <and...@dunslane.net> wrote: > Say I'm writing an extension X, and I want to process data values from > another extension that creates type Y (e.g. an hstore), what's the best way > to determine the Oid of type Y in my module X code? SPI code that runs > "select 'something'::Y" and then examines the oid in SPI_tuptable? Or do we > have a utility function I have missed that, given a type name and the > current search path will give me back the type Oid?
Does this help? test=# SELECT pg_typeof('4834.34'::numeric)::oid; pg_typeof ----------- 1700 (1 row) -- Thom -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers