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

On 12/20/05, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> jmadm <jmadm@montevideo.com.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 ;)