Στις 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
