背景

今天系统发送权益的时候因为权益批次号失效了，导致一些权益未发送成功，有失败记录；需要将现有的权益模板里面的批次号和失败记录批次号修改之后重发；

sql语句拼写

修改模板批次号sql

update table set params = jsonb_set(params,'{key}','"批次号"'::jsonb, false),update_time = now() where id = "id";

修改失败权益记录sql

update table set params = jsonb_set(params,'{parames,0,batchCode}','"批次号"'::jsonb, false),update_time = now() where create_time > '2021-10-01 00:01:00' and state = 3 and field_id = 'id';

update table set params = jsonb_set(params,'{activityId}','"批次号"'::jsonb, false),update_time = now() where create_time > '2021-10-15 00:01:00' and state = 3 and field_id = 'id';