Re: merge documentation fix

Lists: pgsql-hackers
From: "Euler Taveira" <euler(at)eulerto(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Cc: "Alvaro Herrera" <alvherre(at)alvh(dot)no-ip(dot)org>
Subject: merge documentation fix
Date: 2022-04-01 20:59:51
Message-ID: 01dea9ef-85ad-4e09-a783-a1eadeae7bbe@www.fastmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
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/


From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Euler Taveira <euler(at)eulerto(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: merge documentation fix
Date: 2022-04-02 15:19:26
Message-ID: 202204021519.cduqchf35kuw@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

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)