postgres.git / summary / log / commit / refs
commit 5dcebd10baa8ec14a97029ca0bacaf2a9a0f8652
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
Date: Fri Sep 09 11:51:45 2022 +0000
First released in: 16.0, 15.0
Doc fixes for MERGE statement
In commit 3d895bc846f2 I introduced a bogus semicolon mid-statement by
careless cut-n-paste; move it. This had already been reported by Justin
Pryzby.
Also, change the styling a bit by avoiding names in CamelCase. This is
more consistent with the style we use elsewhere.
Backpatch to 15.
Author: Vitaly Burovoy <vitaly.burovoy@gmail.com>
Reviewed-by: Vik Fearing <vik@postgresfriends.org>
Discussion: https://postgr.es/m/9afe5766-5a61-7860-598c-136867fad065@gmail.com
Discussion: https://postgr.es/m/20220819133016.GV26426@telsasoft.com
doc/src/sgml/ref/merge.sgml | 28 ++++++++++++++--------------
1 file changed, 14 insertions(+), 14 deletions(-)
diff --git a/doc/src/sgml/ref/merge.sgml b/doc/src/sgml/ref/merge.sgml
index a129a6edd5b..e07addaea42 100644
--- a/doc/src/sgml/ref/merge.sgml
+++ b/doc/src/sgml/ref/merge.sgml
@@ -554,18 +554,18 @@ MERGE <replaceable class="parameter">total_count</replaceable>
<title>Examples</title>
<para>
- Perform maintenance on <literal>CustomerAccounts</literal> based
- upon new <literal>Transactions</literal>.
+ Perform maintenance on <literal>customer_accounts</literal> based
+ upon new <literal>recent_transactions</literal>.
<programlisting>
-MERGE INTO CustomerAccount CA
-USING RecentTransactions T
-ON T.CustomerId = CA.CustomerId
+MERGE INTO customer_account ca
+USING recent_transactions t
+ON t.customer_id = ca.customer_id
WHEN MATCHED THEN
- UPDATE SET Balance = Balance + TransactionValue
+ UPDATE SET balance = balance + transaction_value
WHEN NOT MATCHED THEN
- INSERT (CustomerId, Balance)
- VALUES (T.CustomerId, T.TransactionValue);
+ INSERT (customer_id, balance)
+ VALUES (t.customer_id, t.transaction_value);
</programlisting>
</para>
@@ -575,14 +575,14 @@ WHEN NOT MATCHED THEN
during execution.
<programlisting>
-MERGE INTO CustomerAccount CA
-USING (Select CustomerId, TransactionValue From RecentTransactions) AS T
-ON T.CustomerId = CA.CustomerId
+MERGE INTO customer_account ca
+USING (SELECT customer_id, transaction_value FROM recent_transactions) AS t
+ON t.customer_id = ca.customer_id
WHEN MATCHED THEN
- UPDATE SET Balance = Balance + TransactionValue;
+ UPDATE SET balance = balance + transaction_value
WHEN NOT MATCHED THEN
- INSERT (CustomerId, Balance)
- VALUES (T.CustomerId, T.TransactionValue)
+ INSERT (customer_id, balance)
+ VALUES (t.customer_id, t.transaction_value);
</programlisting>
</para>
[parent: 8c848cd4b8e9]