审查视图

sql/2023-04-03.sql 280 字节
tangxvhui authored
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
-- 调整旧数据
WITH t1 AS (
    SELECT
        evaluation_cycle.id AS cycle_id
    FROM
        evaluation_cycle
    WHERE
        deleted_at IS NOT NULL)
UPDATE
    summary_evaluation
SET
    deleted_at = now()
FROM
    t1
WHERE
    summary_evaluation.cycle_id = t1.cycle_id