Thread

1. Feature Request - PL/PgSQL

   Gavin Sherry <swm@linuxworld.com.au> — 2001-10-14T13:05:15Z

   Hi all,
   
   It would be very nice if PL/PgSQL could return a record set (ie, set of
   tuples). This could be done in two ways as far as I can imagine: either
   PL/PgSQL just returns the rows as a normal query would or it could return
   a cursor. The prior would be very useful, the latter easier to implement
   (especially if INOUT arguments get implemented =)).
   
   Currently, this seems to go against the grain of PL/PgSQL - am I missing
   something?
   
   Gavin
   
   
   

2. Re: Feature Request - PL/PgSQL

   Alex Pilosov <alex@pilosoft.com> — 2001-10-14T15:08:30Z

   You already can return a cursor.
   
   Support for returning a record set is being worked on.
   
   -alex
   On Sun, 14 Oct 2001, Gavin Sherry wrote:
   
   > Hi all,
   > 
   > It would be very nice if PL/PgSQL could return a record set (ie, set of
   > tuples). This could be done in two ways as far as I can imagine: either
   > PL/PgSQL just returns the rows as a normal query would or it could return
   > a cursor. The prior would be very useful, the latter easier to implement
   > (especially if INOUT arguments get implemented =)).
   > 
   > Currently, this seems to go against the grain of PL/PgSQL - am I missing
   > something?
   > 
   > Gavin
   > 
   > 
   > ---------------------------(end of broadcast)---------------------------
   > TIP 5: Have you checked our extensive FAQ?
   > 
   > http://www.postgresql.org/users-lounge/docs/faq.html
   > 
   >