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. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
