Re: Fetch for Update

From: Christophe <xof(at)thebuild(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Fetch for Update
Date: 2008-07-28 16:46:43
Message-ID: 5B447E41-0EDD-4500-92EC-28EFD21710BC@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Jul 28, 2008, at 9:16 AM, Bob Pawley wrote:

> I haven't been able to find much information on Fetch for Update.
> Does 8.3 support this command??

Postgres doesn't have an explicit FETCH FOR UDPATE. You can either
create the cursor with SELECT FOR UPDATE, or UPDATE the row in the
cursor using UPDATE ... CURRENT OF.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message aravind chandu 2008-07-28 17:01:01 errors while working on xml functions in postgresql
Previous Message Garg, Manjit 2008-07-28 16:44:46 Clone a database to other machine