Return the final row after DML

CREATE DATABASE cookbook_returning;
CREATE TABLE cookbook_returning.orders(id INT PRIMARY KEY, amount INT);
INSERT INTO cookbook_returning.orders VALUES(1,10) RETURNING id,amount;
UPDATE cookbook_returning.orders SET amount=15 WHERE id=1
RETURNING id,amount;
DELETE FROM cookbook_returning.orders WHERE id=1 RETURNING id,amount;
SELECT COUNT(*) AS rows_left FROM cookbook_returning.orders;
DROP DATABASE cookbook_returning;

The three RETURNING clauses should give (1,10), (1,15), and (1,15) respectively; then rows_left=0. The result is a final row image for supported single-table DML, not an old/new pair. See the source DML RETURNING test for boundaries.