UPDATE/DELETE XXX WHERE CURRENT OF cursor_name

From: "Golden Liu" <goldenliu(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: UPDATE/DELETE XXX WHERE CURRENT OF cursor_name
Date: 2006-07-24 08:20:34
Message-ID: 2d3034200607240120u13876cfbndca7d922faf7f94e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Updateable cursors are used as follows:

begin;
declare foo cursor for select * from bar for update;
fetch foo;
update bar set abc='def' where current of foo;
fetch foo;
delete from bar where current of foo;
commit;

PostgreSQL doesn't support this feature now ( 8.1.4). Will PGSQL
support it recently? Does anyone work on this?

thanks
Golden
7.24

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Csaba Nagy 2006-07-24 08:33:15 Re: Transaction Speed and real time database
Previous Message Dave Page 2006-07-24 07:31:01 Re: Adding a pgbench run to buildfarm