79792581

Date: 2025-10-16 21:22:46
Score: 1
Natty:
Report link

Postgresql 18 now supports OLD and NEW in RETURNING clauses. From the manual example.

UPDATE products SET price = price * 1.10
  WHERE price <= 99.99
  RETURNING name, old.price AS old_price, new.price AS new_price,
            new.price - old.price AS price_change;
Reasons:
  • Probably link only (1):
  • Low length (0.5):
  • Has code block (-0.5):
Posted by: Dean Serenevy