By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,542 Members | 1,434 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,542 IT Pros & Developers. It's quick & easy.

SELECT 'pg_catalog.pg_class'::regclass::oid

P: n/a
Hi list,

test=# SELECT 'pg_catalog.pg_class'::regclass::oid;
oid
------
1259
(1 row)

test=# SELECT '1259'::oid::regclass;
regclass
----------
pg_class
(1 row)

test=# SELECT '1259'::oid::regclass::text || '.relname';
ERROR: cannot cast type regclass to text
test=#

Could the regclass psuedo-type give schema qualified output when given an
oid, and could it be castable to text please - it would make life easier?
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.