간단히 예만 들어보면

create table A( f text );

create table B( a datetime,b text );

-- 홑따옴표 두개에 유의하시고

create or replace function afunc() returns opaque as '

begin

if new.f in (''1'',''2'') then

insert into B values( now(),''ok'' );

end if;

return new;

end;

' language 'plpgsql';

create trigger trig after update on A for each row

execute procedure afunc();

insert into A values( '464' );

update A set f='2';

--->

select * from B;

함수와 트리거대신

create rule rulname as on update A

where new.f in ( '1','2' )

do (

insert into B values( now(),'ooo');

);

이렇게 해도 될거구요