Re: ToDo List Item - System Table Index Clustering

2011/1/16 Simone Aiken <saiken@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