Re: Function returning setof more than 1 table

["Merlin Moncure" <mmoncure(at)gmail(dot)com>]

On 10/27/06, J S B <jsbali(at)gmail(dot)com> 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 can pass them to other functions,   kind of
like handles to query results.

in pure sql, you pretty much have to write to temp tables.  make sure
you create the temp table before you run the function...

merlin