2011/1/16 Simone Aiken <sai...@ulfheim.net>: > is there a way to make queries on the system tables show me what > is actually there when I'm poking around? So for example: > > Select * from pg_type limit 1; > > tells me that the typoutput is 'boolout'. An english string rather > than > a number. So even though the documentation says that column > maps to pg_proc.oid I can't then write: > > Select * from pg_proc where oid = 'boolout';
Type type of typoutput is "regproc", which is really an oid with a different output function. To get the numeric value, do: Select typoutput::oid from pg_type limit 1; Nicolas -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
