[php]
test=# create table tg (id int, val text);
CREATE TABLE
test=# insert into tg values (1, ‘alt’);
INSERT 0 1
test=# create or replace function tgf () returns trigger as $$begin raise notice ‘% %’,OLD.val, NEW.val;return NEW; end; $$language plpgsql;
CREATE FUNCTION
test=# create trigger tg1 after update on tg for each row execute procedure tgf();
CREATE TRIGGER
test=# update tg set val=‘neu’ where id=1;
NOTICE: alt neu
UPDATE 1
[/php]