Re: Cursor
От | Bob Pawley |
---|---|
Тема | Re: Cursor |
Дата | |
Msg-id | 00e401c8f1c7$64e53cf0$6401a8c0@owner обсуждение исходный текст |
Ответ на | Re: Cursor (aklaver@comcast.net (Adrian Klaver)) |
Список | pgsql-general |
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 >
В списке pgsql-general по дате отправления: