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

Fetch for Update

From: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
To: "PostgreSQL" <pgsql-general(at)postgresql(dot)org>
Subject: Fetch for Update
Date: 2008-07-28 16:16:22
Message-ID: 00a701c8f0cd$470d8750$6401a8c0@owner (view raw or whole thread)
Lists: 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?


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

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


 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

Next:From: aravind chanduDate: 2008-07-28 16:25:47
Subject: should i need to install xml library in postgresql inorder to work on xml file?
Previous:From: Tom LaneDate: 2008-07-28 15:10:15
Subject: Re: why my postgresql auto crashed???

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