Bob Pawley <rjpawley@xxxxxxx> writes: > I thought the NEW qualified the select. Not at all; that would rather cripple the ability to write interesting triggers. I think what you are really wanting to do here is just insert into p_id.loops (monitor) values (new.devices_id); regards, tom lane