Thanks Tom
Qualifying the column was the solution.
Bob
----- Original Message -----
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Richard Huxton" <[EMAIL PROTECTED]>; "PostgreSQL"
<pgsql-general@postgresql.org>
Sent: Tuesday, July 29, 2008 2:51 PM
Subject: Re: [GENERAL] Cursor
"Bob Pawley" <[EMAIL PROTECTED]> 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;
You probably ought to qualify the column reference in the cursor.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
