postgresql数据库通过触发器解决a字段或c字段值更新，b字段同步更新问题

触发器函数存储过程如下

CREATE OR REPLACE FUNCTION "public"."update_jdgl_gcljs_ghjd_funcs"()
  RETURNS "pg_catalog"."trigger" AS $BODY$
begin
if(NEW.TZ_JHTZ != OLD.TZ_JHTZ) then
update
    jdgl_gcljs_ghjd_tb
set
    TZ_WCL = OLD.TZ_SJTZ*100 / NEW.TZ_JHTZ
where
    NEW.PK_UID = PK_UID;
    end if;
if(NEW.yzl_jhjsrw != OLD.yzl_jhjsrw) then
update
    jdgl_gcljs_ghjd_tb
set
    TZ_WCL = OLD.yzl_sjjsrw*100 / NEW.yzl_jhjsrw
where
    NEW.PK_UID = PK_UID;
end if;
return new;
end $BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100

 创建触发器

CREATE TRIGGER "jdgl_gcljs_ghjd_tb" AFTER UPDATE ON "public"."jdgl_gcljs_ghjd_tb"
FOR EACH ROW
EXECUTE PROCEDURE "public"."update_jdgl_gcljs_ghjd_funcs"();