Re: Full Stored Procedure Support, any time soon ?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Full Stored Procedure Support, any time soon ?
Date: 2013-11-30 22:47:06
Message-ID: 529A6AEA.90900@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Grittner 2013-11-30 23:21:08 Re: [GENERAL] pg_upgrade ?deficiency
Previous Message Noel Diaz 2013-11-30 22:30:59 Re: Full Stored Procedure Support, any time soon ?