Postgres Pro
Downloads
Home   >   mailing lists

Thread: merge documentation fix

merge documentation fix

From
"Euler Taveira"
Date:
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/

Re: merge documentation fix

From
Alvaro Herrera
Date:
On 2022-Apr-01, Euler Taveira wrote:

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

Thanks, pushed.

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/
"The Gord often wonders why people threaten never to come back after they've
been told never to return" (www.actsofgord.com)