X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id A33639DC81C for ; Tue, 20 Dec 2005 15:50:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 46720-08 for ; Tue, 20 Dec 2005 15:50:11 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp.tecnet.com.uy (smtp.tecnet.com.uy [200.2.48.56]) by postgresql.org (Postfix) with ESMTP id ADA6F9DC812 for ; Tue, 20 Dec 2005 15:50:06 -0400 (AST) Received: from [192.168.11.9] ([200.40.51.162]) by smtp.tecnet.com.uy (8.12.10/8.12.10) with ESMTP id jBKJkopS007553 for ; Tue, 20 Dec 2005 17:46:52 -0200 Message-ID: <43A85FA9.3060607@montevideo.com.uy> Date: Tue, 20 Dec 2005 17:46:49 -0200 From: jmadm Reply-To: jmadm@montevideo.com.uy User-Agent: Thunderbird 1.5 (Windows/20051025) MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: Cursors for update.., we have to port an informix 9.x appication using cursors for update Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.359 required=5 tests=[AWL=-0.120, DNS_FROM_RFC_ABUSE=0.479] X-Spam-Score: 0.359 X-Spam-Level: X-Archive-Number: 200512/33 X-Sequence-Number: 5901 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? Thanks for the reply. Jorge