Re: Fetch for Update - Mailing list pgsql-general

From Christophe
Subject Re: Fetch for Update
Date
Msg-id 5B447E41-0EDD-4500-92EC-28EFD21710BC@thebuild.com
Whole thread Raw
In response to Fetch for Update  ("Bob Pawley" <rjpawley@shaw.ca>)
List 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.

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: should i need to install xml library in postgresql inorder to work on xml file?
Next
From: "Garg, Manjit"
Date:
Subject: Clone a database to other machine