| 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: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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 | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Munro | 2022-04-01 21:03:05 | Re: wrong fds used for refilenodes after pg_upgrade relfilenode changes Reply-To: |
| Previous Message | Ekaterina Sokolova | 2022-04-01 20:46:47 | Re: [PATCH] Add extra statistics to explain for Nested Loop |