[GENERAL] Inserting Data

[Bob Pawley]

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