Using cursor for update

[ashokakr]

hi all,
I have a doubt in cursor.Can we use cursor for update query in procedures.
I tried all the cursor concepts but i could not found it, So please help me in giving the syntax for the Update query using Curcor.

[michaelb]

These links should help you:

http://www.postgresql.org/docs/8.2/static/plpgsql-cursors.html

http://www.postgresql.org/docs/8.2/static/sql-declare.html

http://www.postgresql.org/docs/8.2/static/view-pg-cursors.html