Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group