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


Sun, 14 Oct 2001 23:05:15 +1000 (EST)
Gavin Sherry <swm@linuxworld.com.au>
Feature Request - PL/PgSQL
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
> 
> 


Sun, 14 Oct 2001 11:08:30 -0400 (EDT)
Alex Pilosov <alex@pilosoft.com>
Re: Feature Request - PL/PgSQL