Re: Old/New
От | Bob Pawley |
---|---|
Тема | Re: Old/New |
Дата | |
Msg-id | 6778716F973443228EC7F59E628B0B60@desktop обсуждение исходный текст |
Ответ на | Old/New ("Bob Pawley" <rjpawley@shaw.ca>) |
Ответы |
Re: Old/New
|
Список | pgsql-general |
No The table p_id.processes is the start of the fluid_id ident and that column is serial. Bob ----- Original Message ----- From: "Adrian Klaver" <adrian.klaver@gmail.com> To: "Bob Pawley" <rjpawley@shaw.ca> Cc: "Tom Lane" <tgl@sss.pgh.pa.us>; "Postgresql" <pgsql-general@postgresql.org> Sent: Friday, January 22, 2010 3:19 PM Subject: Re: [GENERAL] Old/New On Friday 22 January 2010 3:05:54 pm Bob Pawley wrote: > This is the whole trigger > > > > Begin > > If new.pump1 = 'True' > > then > > Insert into p_id.devices (p_id_id, process_id, fluid_id, status, > process_graphics_id, device_description) > values (new.p_id_id, new.process_id, new.fluid_id, 'Pump #1', '11', > 'Pump'); > > End if; > > If new.pump2 = 'True' > > then > > Insert into p_id.devices (p_id_id, process_id, fluid_id, status, > process_graphics_id, device_description) > values (new.p_id_id, new.process_id, new.fluid_id, 'Pump #2', '11', > 'Pump'); > > End if ; > > RETURN NULL; > > END; > > Bob The update statement - update p_id.processes set pump1 = 'True' where p_id.processes.fluid_id = '3501' ; updates the field pump1 to 'True'. Is there more than one row in p_id.processes with p_id.processes.fluid_id = '3501' ? -- Adrian Klaver adrian.klaver@gmail.com
В списке pgsql-general по дате отправления: