gistfile1.sql

WITH old_rows AS (
  SELECT a, b, c
  FROM update_me
  WHERE blah = true
), new_rows AS (
  UPDATE update_me
  SET a = 4, b = 5, c = 6
  FROM old_rows
  WHERE blah = true
)
SELECT *
FROM old_rows;