Fetch for Update - Mailing list pgsql-general

From Bob Pawley
Subject Fetch for Update
Date
Msg-id 00a701c8f0cd$470d8750$6401a8c0@owner
Whole thread Raw
Responses Re: Fetch for Update
Re: Fetch for Update
List pgsql-general
I haven't been able to find much information on Fetch for Update. Does 8.3
support this command??

If so, could someone please point out my error in the following?

Bob


BEGIN
   SELECT count (p_id.pid.process_id) INTO Proccount
   FROM p_id.p_id
   WHERE process_id = new.process_id;

 Declare
 procgraphic cursor for
 select process_id
 from p_id.p_id
 where p_id.p_id.p_id_id = proc_count.p_id_id;

 Begin

 Fetch first  in procgraphic for update
 Update p_id.p_id
 set proc_graphic_position = one
 From graphics.proc_position
 where graphics.proc_position.proc_count = proccount;


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: why my postgresql auto crashed???
Next
From: aravind chandu
Date:
Subject: should i need to install xml library in postgresql inorder to work on xml file?