Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dynamic Cursors in PostgreSQL

Status
Not open for further replies.

tharas

Programmer
Sep 16, 2006
6
IN
Hello all,

I have a function in which I declared a cursor as REFCURSOR and this curosr selects some rows from a temporary table based on some condition. Within the cursor, I have to make updation to some field values of the temporary table and later execution of the cursor should be based on the new data.

From manuals, I think the above operation requires dynamic cursors. How I can implement dynamic cursors in PostgreSQL? Is it by using dynamic SQLs? Can anyone give me tips on using dynamic SQLs for cursors?


Pls reply... thanks

...thara
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top