On 10/27/06, J S B <jsbali@xxxxxxxxx> 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
