merge documentation fix - Mailing list pgsql-hackers

From Euler Taveira
Subject merge documentation fix
Date
Msg-id 01dea9ef-85ad-4e09-a783-a1eadeae7bbe@www.fastmail.com
Whole thread Raw
Responses Re: merge documentation fix  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List 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

pgsql-hackers by date:

Previous
From: Ekaterina Sokolova
Date:
Subject: Re: [PATCH] Add extra statistics to explain for Nested Loop
Next
From: Thomas Munro
Date:
Subject: Re: wrong fds used for refilenodes after pg_upgrade relfilenode changes Reply-To: