> -----Original Message----- > From: Tom Lane [mailto:[EMAIL PROTECTED]] > Sent: Sunday, May 19, 2002 6:40 PM > To: Joel Burton > Cc: Joe Conway; Pgsql-Hackers@Postgresql. Org > Subject: Re: [HACKERS] Exposed function to find table in schema search > list? > > > "Joel Burton" <[EMAIL PROTECTED]> writes: > > Is the use of regclass going to prove to be very > > implementation-specific? > > Sure, but so would any other API for it.
Well, sort of, but if we had been promoting a function tableoid(text) returns oid, we wouldn't have to make any change for the move to regclass, would we? I mean, it's specific to PG, but a simple wrapper might outlive the next under-the-hood change. On a related note: is there an easy way to use this ::regclass conversion to test if a table exists in a non-error returning way? (Can I use it in a select statement, for instance, returning a true or false value for the existence or non-existence of a table?) - J. Joel BURTON | [EMAIL PROTECTED] | joelburton.com | aim: wjoelburton Knowledge Management & Technology Consultant ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org