Bob Pawley <rjpawley@shaw.ca> 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