Horton

merge documentation fix

Euler Taveira <euler@eulerto.com>

View thread View on postgr.es
From: "Euler Taveira" <euler@eulerto.com>
To: pgsql-hackers@lists.postgresql.org
Cc: "Alvaro Herrera" <alvherre@alvh.no-ip.org>
Date: 2022-04-01T20:59:51Z
Lists: pgsql-hackers 
Hi,

While inspecting the MERGE documentation, I noticed that there is an extra
semicolon in one of the examples that shouldn't be there.

diff --git a/doc/src/sgml/ref/merge.sgml b/doc/src/sgml/ref/merge.sgml
index c547122c9b..ac1c0a83dd 100644
--- a/doc/src/sgml/ref/merge.sgml
+++ b/doc/src/sgml/ref/merge.sgml
@@ -596,7 +596,7 @@ ON s.winename = w.winename
WHEN NOT MATCHED AND s.stock_delta > 0 THEN
   INSERT VALUES(s.winename, s.stock_delta)
WHEN MATCHED AND w.stock + s.stock_delta > 0 THEN
-  UPDATE SET stock = w.stock + s.stock_delta;
+  UPDATE SET stock = w.stock + s.stock_delta
WHEN MATCHED THEN
   DELETE;
</programlisting>


--
Euler Taveira
EDB   https://www.enterprisedb.com/

Commits

  1. Remove excess semicolon in MERGE docs