Στις 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
$$ LA
I have a question to creating a rule:
CREATE RULE dbmail_mailboxes_autocreate AS ON INSERT TO dbmail_users DO
ALSO insert into dbmail_mailboxes (owner_idnr,name) values
(NEW.user_idnr,'INBOX'), (NEW.user_idnr,'Gesendete Objekte'),
(NEW.user_idnr,'Entwürfe'), (NEW.user_idnr,'Junk'),
(NEW.user_