Where Statement

[Bob Pawley <rjpawley@xxxxxxx>]

The following transfers the serial number of fluid_id into the two tables, specification and pipe.

 

However, it doesn't follow the WHERE instruction. All fluid_id serial numbers in process are transferred to fluid_id column in pipe with no discrimination.

 

I can't see what I have done wrong.

 

Bob

------------
 create or replace function base() returns trigger as $$
 begin

 

 insert into specification (fluid_id) values (new.fluid_id);

 

 create table pro as
 select fluid_id from process where ip_op_reactor = 'ip';
 insert into pipe (fluid_id) values (new.fluid_id);
 
 drop table pro ;
 return null;
 
 end;
 $$ language plpgsql;

 

 create trigger trig1 after insert on process
 for each row execute procedure base();