[ppos]

Hello,
I need to duplicate/set some values beyond application that performs real database inserts. I tried with triggers with a piece of code like this:

CREATE PROCEDURE pp_today() RETURNING DATE;
RETURN today;
END PROCEDURE;

CREATE TRIGGER ins_prhed
INSERT ON prhed
FOR EACH ROW (EXECUTE PROCEDURE pp_today() INTO prhed_insdate);

The trigger sets the fileld 'prhed_insdate' with current date. Is it possible to get the same result without using stored procedures ?

Second example is field duplication in insert:

CREATE PROCEDURE pp_passdate (in_date DATE) RETURNING DATE;
RETURN in_date;
END PROCEDURE;

CREATE TRIGGER ins_pltran
INSERT ON pltran
REFERENCING NEW AS new_fak
FOR EACH ROW (EXECUTE PROCEDURE pp_passdate(new_fak.plt_duedate)
INTO plt_origdue);

And the question is the same, how to get rid of store procedure ? All what I need is to do an assignment 'plt_origdue = plt_duedate'

Waiting for your help, best regards
Pawel