Hello 2009/9/28 Thom Brown <thombr...@gmail.com>: > Hi, > > Is it possible to create a function using 'SQL' as language which could > return multiple rowsets, such as "SELECT * FROM TABLE1; SELECT * FROM > TABLE2;" where both results are returned in the output? I know this can be > done in stored procedures in other RBDMS but can this be done in a function? >
it is possible, but not directly. You can returns setof refcursors see http://www.postgresql.org/docs/8.2/static/plpgsql-cursors.html regards Pavel Stehule > Thanks > > Thom > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
