Στις Saturday 21 February 2009 10:43:35 ο/η Michael Monnerie έγραψε: > $$ LANGUAGE plpgSQL;
do smth like: CREATE or REPLACE function foofunc() RETURNS TRIGGER as $$ BEGIN insert into test2(descr) values(new.descr); INSERT into test2(descr) values(new.descr||'FOOBAR'); RETURN NEW; END $$ LANGUAGE plpgSQL; CREATE TRIGGER foofunc_trig AFTER INSERT ON test1 FOR EACH ROW EXECUTE PROCEDURE foofunc(); -- Achilleas Mantzios -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
