On 11/30/2013 2:30 PM, Noel Diaz wrote:
This might involve the control of transaction state and the return of multiple result sets* PL/pgSQL stored procedure returning multiple result sets (SELECTs)? <http://archives.postgresql.org/pgsql-general/2008-10/msg00454.php> * Proposal: real procedures again (8.4) <http://archives.postgresql.org/pgsql-hackers/2007-10/msg01375.php> * http://archives.postgresql.org/pgsql-hackers/2010-09/msg00542.php * Gathering specs and discussion on feature (post 9.1) <http://archives.postgresql.org/pgsql-hackers/2011-04/msg01149.php> Does anybody know if any the committers are working on that list?
I don't think the libpq API will allow that first one, a SQL query can only return a single recordset of rows that all have the same fields.
-- john r pierce 37N 122W somewhere on the middle of the left coast
