On Sat, 30 Mar 2002, Madhavi Daroor wrote:
> Can anybody please let me know how I can return cursors using plpgsql in
> postgresql.
> I'm moving my database from oracle to postgresql. I have lot of reports in
> Oracle that have to be converted to postgreSql. But I'm returning cursors in
> all the functions. I could not find any such option in postgresql. So please
> let me know how I can return record sets/cursors in postgresql functions.
I believe you can return open cursors from plpgsql via the refcursor
type as of 7.2. I believe there's some documentation in the 7.2 plpgsql
documentation of how to open the cursors and such.