retun cursor 
Author Message
 retun cursor


>    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.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command

Sun, 19 Sep 2004 04:34:12 GMT
 [ 1 post ] 

 Relevant Pages 

1. retun cursor

2. Retun values in strored procedure

3. Carriage Retun in SQL

4. Retun Only Fields That contain duplicate information

5. Cursor Cursor Cursor

6. cursor without cursors

7. help-no open cursor or cursor closed

8. Different error for client cursor and server cursor

9. Cursor in Trigger - with cursor not open when running second time in the same SQL session

10. 40088 No open cursor or cursor closed.

11. global cursors vs. local cursors

12. Why declare cursor and open cursor both cost same amount of time

Powered by phpBB® Forum Software