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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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