On 11/15/05, Bob Pawley <rjpawley@xxxxxxx> wrote: > No - I mean when each row of pr (contain) has 'ip' inserted as a value or > data. > > Bob > create or replace function base() returns trigger as $$ begin if new.contain = 'ip' then insert into pi (fluid_id) values (new.fluid_id); end if; return null; end; $$ language plpgsql; -- Atentamente, Jaime Casanova (DBA: DataBase Aniquilator ;) ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend