From 0af504733c6e9198067705822e7527dc4e60b4f6 Mon Sep 17 00:00:00 2001 From: Alvaro Herrera Date: Sat, 2 Apr 2022 17:16:32 +0200 Subject: [PATCH] Remove excess semicolon in MERGE docs Author: Euler Taveira Discussion: https://postgr.es/m/01dea9ef-85ad-4e09-a783-a1eadeae7bbe@www.fastmail.com --- doc/src/sgml/ref/merge.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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; -- 2.39.5