"David E. Wheeler" <da...@kineticode.com> writes: > On May 4, 2011, at 3:04 PM, Alvaro Herrera wrote: >> As someone commented downthread, they also want to have things such as a >> "typeof" operator. It could be used in (say) a plpgsql function to >> choose different branches of code.
> FWIW, pg_typeof(any) has been in core since 9.0. But note that pg_typeof() would surely say "VARIANT" if applied to such a datatype. You'd need some other, VARIANT-specific function that knew enough to dig into the value at runtime and get the OID therein. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers