定义一个函数:
CREATE OR REPLACE FUNCTION update_date_field()
RETURNS VOID AS $$
DECLARE
row record;
BEGIN
-- 遍历要更新的记录
FOR row IN SELECT id,evaluation_date FROM account_cable_section WHERE evaluation_date is not null LOOP
-- 更新日期字段为随机生成的日期
UPDATE account_cable_section
SET evaluation_date = '2023-06-01'::DATE + (random() * ('2023-07-31'::DATE - '2023-06-01'::DATE))::INT
WHERE id = row.id;
END LOOP;
END;
$$ LANGUAGE plpgsql;
执行函数:
SELECT update_date_field ();
大功告成: