PostgreSQL 7.4.5, 8.0.0beta3
The Object Identifier Types section of the PostgreSQL documentation
contains the following:
for example, one may write 'mytable'::regclass to get the OID
of table mytable, rather than SELECT oid FROM pg_class WHERE
relname = 'mytable'.
To get the OID, don't we then need to cast to the oid type?
test=> SELECT 'mytable'::regclass;
regclass
----------
mytable
(1 row)
test=> SELECT 'mytable'::regclass::oid;
oid
-------
26664
(1 row)
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/