Re: [GENERAL] Need help with generic query

2007-06-29 Thread Jim Nasby
No idea on the function, but why not have a 'master' ticket table and have the ones in each schema inherit from it? Then you could query all tables by just querying the master table. On Jun 20, 2007, at 5:55 AM, David Abrahams wrote: Background: I have a number of schemas all of which conta

Re: [GENERAL] Need help with generic query

2007-06-20 Thread Rodrigo De León
On Jun 20, 5:55 am, David Abrahams <[EMAIL PROTECTED]> wrote: > The problem is, psql is complaining: > > ERROR: wrong record type supplied in RETURN NEXT Try: ... RETURNS SETOF RECORD ... ---(end of broadcast)--- TIP 1: if posting/reading throu