Re: Cursors for update.., we have to port an informix 9.x appication using cursors for update

[Jaime Casanova <systemguards(at)gmail(dot)com>]

On 12/20/05, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> jmadm <jmadm(at)montevideo(dot)com(dot)uy> writes:
> > We have to port an application from Informix 9 CSQL to Postgres 8.1
> > using Ecpg.
>
> > Informix application uses cursors for update to lock all the rows
> > involved in those cursor. Then an update my occur ussing Current of.
>
> > How we can do this with postgres?
>
> You can use SELECT FOR UPDATE in the cursor,

in the cursor or instead of the cursor? IIRC, cursors are read only in postgres

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)