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 6C15C9DCA46
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Wed, 21 Dec 2005 14:23:14 -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 92648-02
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Wed, 21 Dec 2005 14:23:12 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from moutng.kundenserver.de (moutng.kundenserver.de
	[212.227.126.188])
	by postgresql.org (Postfix) with ESMTP id CB4B89DC84A
	for <pgsql-interfaces@postgresql.org>;
	Wed, 21 Dec 2005 14:23:09 -0400 (AST)
Received: from [195.158.156.2] (helo=feivel)
	by mrelayeu.kundenserver.de (node=mrelayeu7) with ESMTP (Nemesis),
	id 0ML2Dk-1Ep8cC1CIp-0005sO; Wed, 21 Dec 2005 19:23:04 +0100
Received: from feivel (feivel [127.0.0.1])
	by feivel (Postfix) with ESMTP id 2A4CF4B5DD;
	Wed, 21 Dec 2005 19:23:03 +0100 (CET)
From: Michael Meskes <meskes@postgresql.org>
To: pgsql-interfaces@postgresql.org,
 jmadm@montevideo.com.uy
Subject: Re: Cursors for update..,
	we have to port an informix 9.x appication using cursors for update
Date: Wed, 21 Dec 2005 19:23:02 +0100
User-Agent: KMail/1.9.1
References: <43A85FA9.3060607@montevideo.com.uy>
In-Reply-To: <43A85FA9.3060607@montevideo.com.uy>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200512211923.02637.meskes@postgresql.org>
X-Provags-ID: kundenserver.de abuse@kundenserver.de
	login:da5cff6069dd6897c77170232368d0ba
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0 required=5 tests=[none]
X-Spam-Score: 0
X-Spam-Level: 
X-Archive-Number: 200512/38
X-Sequence-Number: 5906

Am Dienstag, 20. Dezember 2005 20:46 schrieb jmadm:
> 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?

IIRC there used to be some patches on gborg to implement WHERE CURRENT OF. I 
have no idea though whether they work with 8.1.

Michael
-- 
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!