postgresql通过触发器实现a表插入一条数据时，a表中的某字段自动赋值当前年度

创建触发器函数

CREATE OR REPLACE FUNCTION "public"."update_test_funcs"()
  RETURNS "pg_catalog"."trigger" AS $BODY$  
    BEGIN  
        UPDATE test SET niandu = to_char((CURRENT_DATE)::timestamp with time zone, 'yyyy'::text) where pk_uid = NEW.PK_UID;
                RETURN NEW;
    END;  
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100

 

创建触发器

CREATE TRIGGER "update_test_trigger" AFTER INSERT ON "public"."test"
FOR EACH ROW
EXECUTE PROCEDURE "public"."update_test_funcs"();