Re: Question on rule

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