Re: Cursor - Mailing list pgsql-general

From Tom Lane
Subject Re: Cursor
Date
Msg-id 16880.1217367352@sss.pgh.pa.us
Whole thread Raw
In response to Re: Cursor  (Richard Huxton <dev@archonet.com>)
Responses Re: Cursor
List pgsql-general
Richard Huxton <dev@archonet.com> writes:
> Bob Pawley wrote:
>> 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

No, he does need an OPEN.  The extract looks correct as far as it goes,
so I think the mistake was in something that was omitted.

            regards, tom lane

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Cursor
Next
From: "Bob Pawley"
Date:
Subject: Re: Cursor