Re: UPDATE/DELETE XXX WHERE CURRENT OF cursor_name

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.