postgresql 批量更新

<update id="updateBatch">
    UPDATE 你的表 t
    SET
    update_by = c.update_by,
    update_date = c.update_date,
    plant = COALESCE(NULLIF(c.plant, ''), t.plant),
    status = COALESCE(NULLIF(c.status, ''), t.status),
    remark = COALESCE(NULLIF(c.remark, ''), t.remark),
    mail = COALESCE(NULLIF(c.mail, ''), t.mail),
    change_record = COALESCE(NULLIF(c.change_record, ''), t.change_record)
    FROM (VALUES
    <foreach collection="list" item="item" separator=",">
        (#{item.id}, #{item.updateBy}, #{item.updateDate},
        #{item.plant}, #{item.status}, #{item.remark},
        #{item.mail}, #{item.changeRecord})
    </foreach>
    ) AS c(id, update_by, update_date, plant, status, remark, mail, change_record)
    WHERE t.id = c.id
    AND t.is_enable = 1
</update>