On 22 February 2012 18:34, Kevin Grittner <[email protected]> wrote: > Thom Brown <[email protected]> wrote: >> Does this help? >> >> test=# SELECT pg_typeof('4834.34'::numeric)::oid; >> pg_typeof >> ----------- >> 1700 >> (1 row) > > Wouldn't it be easier to do this instead? > > test=# SELECT 'numeric'::regtype::oid; > oid > ------ > 1700 > (1 row)
Well I may have misread the problem. I thought it was that for a particular data value, the oid of the type of that value was needed. -- Thom -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
