Report question

Question: PostgreSql -> CTE + UPDATE + DELETE -> not expected result, why?