/*创建序列*/
CREATE SEQUENCE "public"."gcgl_zdht_tb_htbh_seq"
INCREMENT 1
MINVALUE 1
MAXVALUE 1000000000
START 1
CACHE 1;
ALTER SEQUENCE "public"."gcgl_zdht_tb_htbh_seq" OWNER TO "postgres";
/*创建触发器函数*/
CREATE OR REPLACE FUNCTION "public"."update_gcgl_zdht_tb_htbh_funcs"()RETURNS "pg_catalog"."trigger" AS $BODY$ BEGIN UPDATE gcgl_zdht_tb SET htbh =RIGHT(jydw,1) ||RIGHT(jyFGS,2)||'DZ'||RIGHT('00'||nextval('gcgl_zdht_tb_htbh_seq'),3) where pk_uid= NEW.PK_UID ;RETURN NEW;END;
$BODY$LANGUAGE plpgsql VOLATILECOST 100
/*创建触发器*/
CREATE TRIGGER "update_gcgl_zdht_tb_htbh_trigger" AFTER INSERT ON "public"."gcgl_zdht_tb"
FOR EACH ROW
EXECUTE PROCEDURE "public"."update_gcgl_zdht_tb_htbh_funcs"();