Re: Cursor
От | Bob Pawley |
---|---|
Тема | Re: Cursor |
Дата | |
Msg-id | 00db01c8f1c7$2f9fb200$6401a8c0@owner обсуждение исходный текст |
Ответ на | Cursor ("Bob Pawley" <rjpawley@shaw.ca>) |
Ответы |
Re: Cursor
|
Список | pgsql-general |
Thanks Tom Qualifying the column was the solution. Bob ----- Original Message ----- From: "Tom Lane" <tgl@sss.pgh.pa.us> To: "Bob Pawley" <rjpawley@shaw.ca> Cc: "Richard Huxton" <dev@archonet.com>; "PostgreSQL" <pgsql-general@postgresql.org> Sent: Tuesday, July 29, 2008 2:51 PM Subject: Re: [GENERAL] Cursor > "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; > > You probably ought to qualify the column reference in the cursor. > > regards, tom lane
В списке pgsql-general по дате отправления: