Inserting Data

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