Thread: 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: > 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 > >