Re: Cursor

Yes

Bob

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

> -------------- Original message ----------------------
> From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>> "Bob Pawley" <rjpawley(at)shaw(dot)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(at)comcast(dot)net
>