Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

Next:From: Bob PawleyDate: 2008-07-29 21:42:45
Subject: Re: Cursor
Previous:From: Richard HuxtonDate: 2008-07-29 21:15:09
Subject: Re: Cursor

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group