Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ovjVD-0003SX-8Z for pgsql-docs@arkaria.postgresql.org; Thu, 17 Nov 2022 18:20:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ovjVB-0008EU-G2 for pgsql-docs@arkaria.postgresql.org; Thu, 17 Nov 2022 18:20:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ovjVA-0008E8-UZ for pgsql-docs@lists.postgresql.org; Thu, 17 Nov 2022 18:20:41 +0000 Received: from sonic305-20.consmr.mail.gq1.yahoo.com ([98.137.64.83]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ovjV7-0003iU-Q0 for pgsql-docs@lists.postgresql.org; Thu, 17 Nov 2022 18:20:40 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1668709233; bh=XY4V7VK/Vz+uGwr1FdUUdAySIOPlp3G2zSQhT1pDqhI=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=HdJig+y4FyxySCHqvMRfYY7oPdhodeLur3PnJbWGtSN5jlUh0ZkKMiK63ZckzvTwsQTePSEArBaRKBN64a79FwqZsEE/moVqCv1UGyAgtoH/yOgd4sLXbaI2OMy/SOMTYrdzXxxkgA5SBY3v2sr6urHcx3sW5LJkPta9JxEaBrfn1jU8Bnh0myrfBX/jiloXircZeGGeRQKtsd732t8TEXJq0/p2o9LuZ/V/JxBv6EnliACGgKvyP7UZ1TfLnGvOtyDxfIMRHHmoJGYEB+TkCU+O92PdNX4GJ+YlXceON/p7NEtRFxLbGcGixSdFe6D8EVW8F3UMPVruMybrt4kcnQ== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1668709233; bh=aScQL8TSazG+w/X0br/2n+hIP6/Oy24nYF/dL5sqBZ/=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=Noe6P5xCbdgxi8lrgwd1lAzqor6SU2idef6dIrRqK91j/MQW3LLzbojB7sV6C+t5Yfu90x7vXfqoPY20F7CNXMvnPw6pKLfXc2eZtwGBMQkoz3Hysbwo6yJB1XnYH6zNMLLt7y18XpOJyILDL/7EVXpJWXtflw1ABwiEJCmZ6sGZoVZIazw/7i/ESyu22fYEkZDOYq2EEu9Qv+/6jbXpBOhX60wN76eFtq9w7rsl9dI6TrUE9Sz3Buoop+aGSaZLuWMf8uqWSb6O3eaU7QC+Zs1w7CxeIH9hbPbvAcoaJI7StFDDTKJYfMwQzIJ05EZZGI00ip31cMGz6qclAZjG8g== X-YMail-OSG: fseBVZoVM1kTF5WiiG6fFqzkZF1I_E2NNNaIOFnZ5t00j_Y9059Xr5r2qsy8KKf 7m9naUDVFO1wV_htYgesOPEdLeWTmILi1LO88B0QU79qKUrU9cewji.Gxq.T4u1g.c_upOBnI5Ut Sw4NMmRiLpjRBmtHiX18IuD_poesD6i8mUdo_TEXRwLVzzg7QH_22uyN..t8WY3ix8AdDBSzI1Z7 D_9BkP7ZWa6EakVDfBwLV_TGrXx.OcA.X21Qjjh0Tk9xMjqI9CfaviW70LeHrNmrtAhv.piz1x6T 0WRVZAqwe5TSKR33gHv2.M8.NyjkRCroQeKLXEv3rc6IoHEjIqGUV5AhrrSahzt2FSLPk3bZ6b1S sDRfxFPjzy_9IUsOiWcDREPRmyEdjUcY2pAZs.FsX0Y.NlEELkXs5KtuViaIplPP2QIz5l3a55Yq E90j1u0.PsdBXSiUXcf408wfp2mH4EsfpPZxUxBltmHWhhV7zwk3zF4QLbUxBxZi1G11Qf22Ppcu YkrXvzjqzvGMLc_IMKs0KeQ8YTeQZkYSgDrwd.9SYOAwfubqg4hKfjoh7dlF8RiYlybQlfHF5pSn _gPms2Vz1V_9idqmyp4LriKZe1.AWVz2ENjrxG5sPruI19rqcyYn8mEarwt14VJbxBcg9Y2oJFdZ 7EGW1ls7vLcIFDYxhqY8W0J_MRb5owN5q5xoN4XHpFR4O36UmPgMyFMhx0X5DGTWmNKSVk82ljtb GzcChlmYwJYNTmYe0CeOWWNm5W4Wi0wcsImgJ4iKPBf5_7nWKaGNtGM55_CaB8qLEGr8nr_amwlV jH0oRWa6LunfAoYlNs5bs4R1jimZts7dBEz59SvQWkaSrizi2goT6t787sZbY2ogtaqHl.dBtyV4 Kq5gaKMsFCjO0bUKKyVasjbKixQ5k3gK7RSBoHNo5dxd7fggN2hU48JYRLrYla1Ps6bAeuJyw32k bJRT.Ie9mTN5vasJ5T9gPxJD8M6CPcvZUYEws4NCa1Dt3cDR2JOy5kXY9zfI.ujeukhSovLuvHdU mndNPtdmWGarxKeR2MOl2PaGkJWnoP3gUVOBZvYqjtd7GI9o.lwrs1N5afIcpXUIeCsJ.qiDFyty hkegEuAzXtxHMNJJo.EOfuhhJLfwIXHUzKQsMHRx5HwXv0P7YoD06RDHGKrbv0SFgWkjKjZCwIEo BBe_4_KQ6CMl2wscadtxomNxHp5Nk5JOwXVzKJnkFW8o4Xlis19U8hOs1uOuSCoe9TGzwqH6Bust .CneE15mOooIM_OVYPEruu4kTbX3xdM7RlTU._BTv137xmf1HM8ao8QGXwV8BaYMZYuHO8rgaz33 .G_KiwEPRmoNRMTGjWlkwArQlvO4RL516NhP4NWDp_kVAd5wHXcRti57nR0JAK78KeAoySYtpnCk TMgAr3NX_MBuS2VowEd8SX8OuduxiimsKGwxYn9OvfP2iu6A1iSHf4Po4N2tOQALOK16mYnPlHX2 DSBtDIs7V7nixmjKlqQ1i6Eeg9rxdaXMSCS5J43FaxTY47_.jYoh7teVw3IJllo07oBEE0trSfFF zE6H6bxEHCMa1c2j3MHm8lgox_X5322m6eRjY09PeOnBt7cGHJCvgpPZLBYxwvJHLvx8s0qG_BH3 VTAaMLBGJjP0npMLUtyirahIzt9CHKowMvejPcsI3thvngULU9OEhNvUFU3yoRuHz_b3_ZsC7Kna bWa9l9rYyh0SDcYZp1lPJVpFgE_P4PqWcAP06ocubJu0NhgYtTwSDEdCgOisStQfWAp8lba56E74 E819elB3TOOYE_q.Asg1Kc6Qm5FwYr9Usn4LlBOzE9Y73Tmfj_8UHHSEN2XAoifHPOZbSCI2zVmY ztzD7s_yCS9ZAoTBUcOIgJHm3MfC4ob1a.t02e97LTqCwEZW0U1kqz1EAVifdG2f0JulLX6o3YiF 4UO8tcO03IYhEu5.dJ3iw6w7f3hAWDkH00zaC4WQ5GW5QNx9ZkJqtZtA4nyHQMspFu0K_Kjd1u.e y6lOW0bX8Bif8m.czxscWzXoCU7114mFRr.2DM6NMyo0fdpNPggo0D1j8MRu0R0gRzvmJ0XcbzGI xZ5Vt4jSHKUVXVV8ujzzYwJhBrOdKtru.3etAGm3QyNCpsR7qs0.YzzfBzZ4PSa2Ip9SL26.tGKr FMjy.2.hyBtb.JqEb.3cXCNlPHJduPp8HhGXOOxrM7tCgugxwDLFZcCJAjElbJ4iih5fH_EBA1w. daoQA3wUM8CU0EoRwCbl_CgRAw0Pfm3A- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic305.consmr.mail.gq1.yahoo.com with HTTP; Thu, 17 Nov 2022 18:20:33 +0000 Date: Thu, 17 Nov 2022 18:20:32 +0000 (UTC) From: Boboc Cristi Reply-To: Boboc Cristi To: "pgsql-docs@lists.postgresql.org" , Alvaro Herrera Message-ID: <1970449059.1357827.1668709232468@mail.yahoo.com> In-Reply-To: <20221117174737.w7jhwzarwmudolue@alvherre.pgsql> References: <166870559096.639.9180457099983661630@wrigleys.postgresql.org> <20221117174737.w7jhwzarwmudolue@alvherre.pgsql> Subject: Re: Merge statement MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1357826_1070281438.1668709232467" X-Mailer: WebService/1.1.20863 YMailNorrin Content-Length: 4956 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_1357826_1070281438.1668709232467 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hello!Thank you. I was fooled by the fact that sometimes it is marked with = [...] and other times with [,...] I think that consistency might worth attention, since [...] may indicate "a= nything", while [,...] are more likely to indicate a specific thing that ma= y be repeated. Best regards, Cristi Boboc=20 On Thursday, November 17, 2022 at 07:47:41 PM GMT+2, Alvaro Herrera wrote: =20 =20 On 2022-Nov-17, PG Doc comments form wrote: > The following documentation comment has been logged on the website: >=20 > Page: https://www.postgresql.org/docs/15/sql-merge.html > Description: >=20 > From the description it looks like a single WHEN clause is accepted, whic= h > is definitely not true. Hmm, the main synopsis has=20 =C2=A0 when_clause [...] where the [...] is there to indicate that when_clause can appear an arbitrary number of times. > Please let us know how many WHEN clauses are accepted for each of WNEM > MATCHED and WHEN NOT MATCHED. There's no specific restriction, although I didn't try to find a limit.=C2=A0 I wonder what happens if you have a few hundred thousand ... Time to experiment, I guess. --=20 =C3=81lvaro Herrera=C2=A0 =C2=A0 =C2=A0 =C2=A0 Breisgau, Deutschland=C2=A0 = =E2=80=94=C2=A0 https://www.EnterpriseDB.com/ "No deja de ser humillante para una persona de ingenio saber que no hay tonto que no le pueda ense=C3=B1ar algo." (Jean B. Say) =20 ------=_Part_1357826_1070281438.1668709232467 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hello!
Thank you. I was fooled by the fact that sometimes it is marked = with [...] and other times with [,...]

I think that consi= stency might worth attention, since [...] may indicate "anything", while [,= ...] are more likely to indicate a specific thing that may be repeated.

Best regards, Cristi B= oboc


=20
=20
On Thursday, November 17, 2022 at 07:47:41 PM GMT+2, Al= varo Herrera <alvherre@alvh.no-ip.org> wrote:


On 2022-Nov-17, PG Doc comments form wrote:

> The following documentation comment has b= een logged on the website:
>
> P= age: https://www.postgresql.org/docs/1= 5/sql-merge.html
> Description:
= >
> From the description it looks like a single WH= EN clause is accepted, which
> is definitely not true.=

Hmm, the main synopsis has

  when_clause [...]
where the [...] is there to indicate that when_clause can a= ppear an
arbitrary number of times.


> Please let us know how many WHEN clauses are accepted for ea= ch of WNEM
> MATCHED and WHEN NOT MATCHED.


There's no specific restriction, although I= didn't try to find a
limit.  I wonder what happens = if you have a few hundred thousand ...
Time to experiment= , I guess.

--
=C3= =81lvaro Herrera        Breisgau, Deutschland  =E2= =80=94  https://www.EnterpriseDB.com/
"No deja de ser humillante para una persona de ingenio saber
que no hay tonto que no le pueda ense=C3=B1ar algo." (Jean B.= Say)
<= br clear=3D"none">
------=_Part_1357826_1070281438.1668709232467--