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

From Gavin Sherry
Subject Re: UPDATE/DELETE XXX WHERE CURRENT OF cursor_name
Date
Msg-id Pine.LNX.4.58.0607241909400.25562@linuxworld.com.au
Whole thread Raw
In response to UPDATE/DELETE XXX WHERE CURRENT OF cursor_name  ("Golden Liu" <goldenliu@gmail.com>)
Responses Re: UPDATE/DELETE XXX WHERE CURRENT OF cursor_name  ("Florian G. Pflug" <fgp@phlo.org>)
List pgsql-hackers
On Mon, 24 Jul 2006, Golden Liu wrote:

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

No one has stepped up to do this for 8.2 so unfortunately you will most
likely not see this within the next year or so :-(.

Thanks,

Gavin

PS: sorry for not responding to your private email in time.


pgsql-hackers by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: Adding a pgbench run to buildfarm
Next
From: Markus Schiltknecht
Date:
Subject: Re: Documenting Replication Solutions