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.