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@xxxxxxxxx>
To: "Bob Pawley" <rjpawley@xxxxxxx>
Cc: "Tom Lane" <tgl@xxxxxxxxxxxxx>; "Postgresql"
<pgsql-general@xxxxxxxxxxxxxx>
Sent: Friday, January 22, 2010 3:19 PM
Subject: Re: 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@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
