What we are trying to figure out is if postgresql supports returning multiple result sets from a stored procedure (psql function?) For example in MSSQL's Northwind database you can create the following stored procedure: <mssql-proc> CREATE PROCEDURE "test" AS SELECT * FROM Orders SELECT * FROM Customers GO </mssql-proc> This would return two datasets from the procedure. We are unsure as to how to map this in to a pgsql equivalent.
