954
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE FUNCTION test_01_insert()
RETURNS trigger AS
$BODY$
BEGIN
IF TG_OP='INSERT' THEN
UPDATE test_table SET b=a1+a2+a3 WHERE test_id=NEW.test_id;
END IF;
return null;
END;
$BODY$
LANGUAGE 'plpgsql';
CREATE TRIGGER test_01_insert
AFTER INSERT
ON test_table
FOR EACH ROW
EXECUTE PROCEDURE test_01_insert();
INSERT INTO test_table (a1,a2,a3) VALUES (1,1,1);