Fetch for Update
| От | Bob Pawley |
|---|---|
| Тема | Fetch for Update |
| Дата | |
| Msg-id | 00a701c8f0cd$470d8750$6401a8c0@owner обсуждение исходный текст |
| Ответы |
Re: Fetch for Update
Re: Fetch for Update |
| Список | pgsql-general |
I haven't been able to find much information on Fetch for Update. Does 8.3 support this command?? If so, could someone please point out my error in the following? Bob BEGIN SELECT count (p_id.pid.process_id) INTO Proccount FROM p_id.p_id WHERE process_id = new.process_id; Declare procgraphic cursor for select process_id from p_id.p_id where p_id.p_id.p_id_id = proc_count.p_id_id; Begin Fetch first in procgraphic for update Update p_id.p_id set proc_graphic_position = one From graphics.proc_position where graphics.proc_position.proc_count = proccount;
В списке pgsql-general по дате отправления: