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