Re: Full Stored Procedure Support, any time soon ?

John R Pierce <pierce@xxxxxxxxxxxx> · Sat, 30 Nov 2013 14:47:06 -0800



    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)?
          Proposal: real
              procedures again (8.4)
          http://archives.postgresql.org/pgsql-hackers/2010-09/msg00542.php
          Gathering specs
              and discussion on feature (post 9.1)
        
        
        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