postgresql 触发器 调用触发函数 更新数据

 

-- 触发器函数
CREATE OR REPLACE FUNCTION "public"."yaoTrigger"() 
      RETURNS trigger  AS $BODY$

 BEGIN
    IF  (TG_OP='UPDATE') THEN 
        INSERT INTO test001 values(NEW.serialno,NEW.payintv,NEW.operator);
    END IF;
    RETURN NEW;
 END;
  $BODY$
  LANGUAGE 'plpgsql';

-- 触发器

CREATE TRIGGER yaogxTrigger AFTER INSERT OR UPDATE ON "public"."laratecommision2"
FOR EACH ROW
EXECUTE PROCEDURE "public"."yaoTrigger"();