Re: Cursor - Mailing list pgsql-general

From Richard Huxton
Subject Re: Cursor
Date
Msg-id 488F885D.2020706@archonet.com
Whole thread Raw
In response to Cursor  ("Bob Pawley" <rjpawley@shaw.ca>)
Responses Re: Cursor  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Bob Pawley wrote:
> I have the following cursor that gives me an error near open.
>
> Can someone please tell me what I am doing wrong??
>  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 ;

There is no OPEN, you just FETCH

> Fetch first from procgraphic into process_id;

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: "Bob Pawley"
Date:
Subject: Cursor
Next
From: Tom Lane
Date:
Subject: Re: Cursor