Re: Cursor

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Bob Pawley <rjpawley(at)shaw(dot)ca>, PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Cursor
Date: 2008-07-29 21:35:52
Message-ID: 16880.1217367352@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard Huxton <dev(at)archonet(dot)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

In response to

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bob Pawley 2008-07-29 21:42:45 Re: Cursor
Previous Message Richard Huxton 2008-07-29 21:15:09 Re: Cursor