2011/1/16 Simone Aiken <saiken(at)ulfheim(dot)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