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 flat)
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?

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;


Responses

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-2014 The PostgreSQL Global Development Group