UPDATE/DELETE XXX WHERE CURRENT OF cursor_name - Mailing list pgsql-hackers

From Golden Liu
Subject UPDATE/DELETE XXX WHERE CURRENT OF cursor_name
Date
Msg-id 2d3034200607240120u13876cfbndca7d922faf7f94e@mail.gmail.com
Whole thread Raw
Responses Re: UPDATE/DELETE XXX WHERE CURRENT OF cursor_name  (Gavin Sherry <swm@linuxworld.com.au>)
List 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?


thanksGolden 7.24


pgsql-hackers by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Adding a pgbench run to buildfarm
Next
From: Csaba Nagy
Date:
Subject: Re: Transaction Speed and real time database