Cursor

From: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
To: "PostgreSQL" <pgsql-general(at)postgresql(dot)org>
Subject: Cursor
Date: 2008-07-29 20:49:52
Message-ID: 007d01c8f1bc$a7a652a0$6401a8c0@owner
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have the following cursor that gives me an error near open.

Can someone please tell me what I am doing wrong??

Bob

DECLARE

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

begin

Open procgraphic ;

Fetch first from procgraphic into process_id;

Responses

  • Re: Cursor at 2008-07-29 21:15:09 from Richard Huxton

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2008-07-29 21:15:09 Re: Cursor
Previous Message Greg Smith 2008-07-29 20:35:08 Re: Index creation and maintenance_work_mem