Inserting Data

[Bob Pawley <rjpawley@xxxxxxx>]

Hi All

 

I have a basic problem that I hope can be addressed.

 

I need to insert data from one table into three other tables.

 

I attempted the following format.

 

 CREATE OR REPLACE FUNCTION p_id_monitor()
 RETURNS "trigger" AS
 $$
 Begin
 insert into p_id.loops (monitor)
 Select p_id.devices.devices_id
 Where p_id.devices.device_number = library.devices.device_number
 and library.devices.type_ = 'mon' ;
 
 insert into p_id.settings (monitor)
 Select p_id.devices.devices_id
 Where p_id.devices.device_number = library.devices.device_number
 and library.devices.type_ = 'mon' ;

 

 insert into p_id.alarms (monitor)
 Select p_id.devices.devices_id
 Where p_id.devices.device_number = library.devices.device_number
 and library.devices.type_ = 'mon' ;

 

 Return Null ;
 End;
 $$
 LANGUAGE 'plpgsql' ;
 create trigger mon after insert on p_id.devices
 for each row execute procedure p_id_monitor() ;

 

Unfortunately this gave multiple results on the target tables.

 

Is there a format that will give me a single insert for each original field without the need of creating three triggers???

 

Bob