diff options
| author | Bruce Momjian <bruce@momjian.us> | 2025-05-08 11:11:08 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2025-05-08 11:11:08 -0400 |
| commit | 9d710a1ac0912244934277a99fe4666df3d2b825 (patch) | |
| tree | a9bfedb323cf7f9debff3cbdc56df9d694082ff0 | |
| parent | 8fcc6487809efa5508a4b70049402236a53be84d (diff) | |
| download | postgresql-9d710a1ac0912244934277a99fe4666df3d2b825.tar.gz postgresql-9d710a1ac0912244934277a99fe4666df3d2b825.zip | |
PG 18 relnotes: adjust RETURNING new/old item
Reported-by: jian he
Discussion: https://postgr.es/m/CACJufxFM1avdwu=OrTx_uMAjTDbFOj1Gp7mnNHOofTVj9QtmRw@mail.gmail.com
| -rw-r--r-- | doc/src/sgml/release-18.sgml | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/doc/src/sgml/release-18.sgml b/doc/src/sgml/release-18.sgml index 4f45c90d7d2..662a74f452c 100644 --- a/doc/src/sgml/release-18.sgml +++ b/doc/src/sgml/release-18.sgml @@ -1432,9 +1432,9 @@ Add OLD/NEW support to RETURNING in DML queries (Dean Rasheed) </para> <para> -Previously RETURNING only returned new values for INSERT and UPDATE, old values for DELETE; MERGE would return the appropriate value for the internal query executed. This new syntax -allows INSERT with an ON CONFLICT action to return old values, UPDATE to return old values, and DELETE to return new values if the query assigned to an ON DELETE row would return new -values. New syntax allows changeable relation aliases "old" and "new" to specify which values should be returned. +Previously RETURNING only returned new values for INSERT and UPDATE, and old values for DELETE; MERGE would return the appropriate value for the internal query executed. This new syntax +allows the RETURNING list of INSERT/UPDATE/DELETE/MERGE to explicitly return old and new values by using the special aliases "old" and "new". These aliases can be renamed to +avoid identifier conflicts. </para> </listitem> |