Re: [HACKERS] Inability to cast regclass is too restrictive

2004-10-09 Thread Oliver Elphick
On Sat, 2004-10-09 at 05:35, Tom Lane wrote: Oliver Elphick [EMAIL PROTECTED] writes: I tried to use regclass() in a plpgsql function to derive a tablename from its oid so as to build a command string, but I am unable to use the value returned because it cannot be cast to anything.

[HACKERS] Inability to cast regclass is too restrictive

2004-10-08 Thread Oliver Elphick
Release 8.0.0.0beta3 I tried to use regclass() in a plpgsql function to derive a tablename from its oid so as to build a command string, but I am unable to use the value returned because it cannot be cast to anything. Therefore I will have to use a complex query on the catalog to do the same

Re: [HACKERS] Inability to cast regclass is too restrictive

2004-10-08 Thread Joe Conway
Oliver Elphick wrote: I tried to use regclass() in a plpgsql function to derive a tablename from its oid so as to build a command string, but I am unable to use the value returned because it cannot be cast to anything. Therefore I will have to use a complex query on the catalog to do the same

Re: [HACKERS] Inability to cast regclass is too restrictive

2004-10-08 Thread Tom Lane
Oliver Elphick [EMAIL PROTECTED] writes: I tried to use regclass() in a plpgsql function to derive a tablename from its oid so as to build a command string, but I am unable to use the value returned because it cannot be cast to anything. Therefore I will have to use a complex query on the