用 RETURNING 取得写入后的行

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;

三次 RETURNING 分别返回 (1,10)、(1,15)、(1,15);最后 rows_left=0。该结果是支持的单表 DML 的最终行镜像,不是 old/new 双版本。边界见源码 DML RETURNING 测试。