在trigger中用 “ execute procedure ... into 非触发字段 ” 实现赋值给字段。 例子如下: create table temp_trig
(a serial,
b integer,
c integer);
CREATE PROCEDURE output_by_input(v_input integer) RETURNING integer;
RETURN v_input;
END PROCEDURE; drop trigger tr_tmp_trig_i ; create trigger tr_tmp_trig_i insert on temp_trig
referencing new as new
for each row
(
execute procedure output_by_input(new.a) into c
); insert into temp_trig (b) values (2);