Feature Request - PL/PgSQL
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
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:
Show quoted text
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?