Re: [GENERAL] Function returning setof more than 1 table

2006-10-27 Thread Merlin Moncure
On 10/27/06, J S B <[EMAIL PROTECTED]> wrote: Can I have a function (language sql) returning SETOF more than one table? Thanks, Jas no, but you can return a record of refcursors. note this is plpgsql. if you are willing to bend on the language, you will find refcursors to be pretty cool, you

Re: [GENERAL] Function returning setof more than 1 table

2006-10-27 Thread A. Kretschmer
am Fri, dem 27.10.2006, um 4:30:47 -0400 mailte J S B folgendes: > Can I have a function (language sql) returning SETOF more than one table? You can create some tables within the function... Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47215, D1: 0160/7141639 (mehr: -> Header) Gn

[GENERAL] Function returning setof more than 1 table

2006-10-27 Thread J S B
Can I have a function (language sql) returning SETOF more than one table?Thanks,Jas