Re: Cursor

Yes

Bob

----- Original Message -----
From: "Adrian Klaver" <aklaver@comcast.net>
To: "Tom Lane" <tgl@sss.pgh.pa.us>; "Bob Pawley" <rjpawley@shaw.ca>
Cc: "Richard Huxton" <dev@archonet.com>; "PostgreSQL"
<pgsql-general@postgresql.org>
Sent: Tuesday, July 29, 2008 3:03 PM
Subject: Re: [GENERAL] Cursor


> -------------- Original message ----------------------
> From: Tom Lane <tgl@sss.pgh.pa.us>
>> "Bob Pawley" <rjpawley@shaw.ca> writes:
>> > Following is more complete. The balance of the trigger that is not
>> > shown
>> > works when tested separately. I didn't include it because it is quite
>> > long.
>>
>> Hmm, I still don't see anything that looks like a syntax error, but
>> I'll bet this is a name collision rather than the effect you want:
>>
>> >  DECLARE
>> >  process_total integer ;
>> >  process_id integer ;
>>    ^^^^^^^^^^
>> >  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;
>                   ^^^^^^^^^^
>
> Just to clarify is this supposed to be schema p_id,table p_id,column
> p_id_id?
>
>>
>> You probably ought to qualify the column reference in the cursor.
>>
>> regards, tom lane
>>
>
>
> --
> Adrian Klaver
> aklaver@comcast.net
>