postgres.git / summary / log / commit / refs

commit    4a9effe45ee96f7105ba19285eff18a634bfee01
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Fri Nov 01 20:20:27 2024 +0000
First released in: 18.0

    doc:  remove useless MERGE example
    
    Reported-by: dwayne.towell@gmail.com
    
    Discussion: https://postgr.es/m/167699245721.1902146.6479762301617101634@wrigleys.postgresql.org
    
    Backpatch-through: master


 doc/src/sgml/ref/merge.sgml | 17 -----------------
 1 file changed, 17 deletions(-)

diff --git a/doc/src/sgml/ref/merge.sgml b/doc/src/sgml/ref/merge.sgml
index 97b34b9fcaf..d80a5c5cc9b 100644
--- a/doc/src/sgml/ref/merge.sgml
+++ b/doc/src/sgml/ref/merge.sgml
@@ -707,23 +707,6 @@ WHEN NOT MATCHED THEN
 </programlisting>
   </para>
 
-  <para>
-   Notice that this would be exactly equivalent to the following
-   statement because the <literal>MATCHED</literal> result does not change
-   during execution.
-
-<programlisting>
-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 + transaction_value
-WHEN NOT MATCHED THEN
-  INSERT (customer_id, balance)
-  VALUES (t.customer_id, t.transaction_value);
-</programlisting>
-  </para>
-
   <para>
    Attempt to insert a new stock item along with the quantity of stock. If
    the item already exists, instead update the stock count of the existing


[parent: e1a76db1a880]