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/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
