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 1ovkDB-0005eO-VO for pgsql-docs@arkaria.postgresql.org; Thu, 17 Nov 2022 19:06:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ovkDA-0005B6-Od for pgsql-docs@arkaria.postgresql.org; Thu, 17 Nov 2022 19:06:08 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ovkDA-0005Ax-Ce for pgsql-docs@lists.postgresql.org; Thu, 17 Nov 2022 19:06:08 +0000 Received: from sonic310-21.consmr.mail.gq1.yahoo.com ([98.137.69.147]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ovkD5-000175-7k for pgsql-docs@lists.postgresql.org; Thu, 17 Nov 2022 19:06:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1668711959; bh=rL3g4AbAnWetF/F353NQ7BC4g1NQwJbANj3WEmeczWI=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=jPpaa9lI0LpTULO4mxMhyPlg6bM+sLVtZXYpbQNrNi/a/1r9pFIKjZhdSUJ0i+vaYag6l3DO6nOggAuy/QIo3/HM58KzQ21P91JwQ+6IRPrxNoJEPdD6ED3CcffC+23LulhQMgb3TMV54Ahu1h3RTGoi7ruA3ACy0YkV+zM3JGkB6eOhvjkA1bvfWWw8/1Gz8lxt8kQLCYXgAHzDxmOgJ3ZkrKzPgzUg1eGOkL+VuwCV3VlqjnrF2bgNfpiYsnthbsE0tmMT+13ZXEfQCfdg1I37ks35P+O9oMwdG4urRqCE9A7bCFDNr3xNvpq5UfPTJSBCXHdWTxG8MF9dQC8EmQ== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1668711959; bh=8hFiaic2xlmNVN05l+8XuQL7ZA4QfW0xGERYB+bwNL7=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=k2eSfxBA9zfOVMyPmjcT0i5TYJ5NASfB2IfWSyRfpyMq1YgopF5qR2vR5O78e1jrglEausWgu+pMV2t5IFuJGRDUvfWQ+ZyKYJ2ktyJYvn2cow2ol/fp/Zu9IrAt5wQuOxp1zRr0d5iDIevQnD0mX2/4FADkvSfS306etKSgEGKCGIIG9esmpHyhVYbRjcogvTSdUFmGHGB5vmSEqB//trkKkxVVlhUi/i4BPkyRU5868+nvFPvIH3w1r9Feve+Fov35OiGPt6kMD9mnPelI6MKHEw83/MWcCybDyxU2ei5OMlwfLq4mHUcbiiy4UOmus3xDYN/QSnuZm2U+iUr+tg== X-YMail-OSG: xwOL0wUVM1msjwBpXIQiBBx47_uzG.NGRVqvOKoABl8MqCABZD3Lv581hCIi5Qg utw2BdIZpBlbxcQRMswdnDe7piOUoNkTdVAmnrRzT0jAmZW2Q1QuSBX_EyEcNREpi2O8rGByD4jD QIpqvh.PtfJMlcTtNJFLymllyO2rR7dYOiCDT2OYxSSBnuCqpyHz_Q_TuuBt7XsHMx3Ojnjy5lzB 89sUgA9m_roJdSUAsrXGVVtshHa57X6ZiLW.WumvwUk8kea3oChggi9MyyglD.pHS5cuQKVYd.LC tlsxHbx_tqeGR_pSTIfNh0XoHTJIELF1Gn3EDMCn39gChpI3wHpp3Ns1.tHNGpnuaQexGdChkQRW qezZQuFfzU2d9FzUnWOJSJjLQUYj94jDrxeH9F2EzsHVSpKOv3rp1redd7c8CFfTGtCJkSeZR15h PuMyMt5NXwnFH7SwXp0iTO9j889I4R_sxBJqIxytXQ9q60Y57sRdot36wMClKOJq0kUMNVUBNACS ASX9wsoQYLgmNbwj6HBe.IRZCXU88BkqMIcqmIdlm9lrkQi2Gs9LKjVlqFsphHSxAIKRNH5uOXq3 iWXPI0R9QJhqceKx_OWM9IEL1w2J2oaNMFTzcTeSXi0lGNt7tsRDbiBOgpL_pniKqITqRcm2kBZ3 lCZYlzOcQ1gA4lTxn2d4GEjaOaEA4mbWq56B8dB5NQdNVgp_9YtNKDiOS76i911r54_kTL3GqlM_ 6Nom5HTAF9gMA_CaqgdfX.GQHmOgQtbQVcU9IQM2HkuYfzjMgQ5UHPwej2tASgsg2gueoVnGirz0 SJHpSQ5wkZxdoeWAnyD.SoBEnvL4_0_O3EnKncRBF.odPxcI4W5pey3QzlshefBCHfGOmMg3NVFk 5RVrfBh7oCTl_h7KXl4F3_JdZemJHIL6bL9T.Hzve7weGDVnI1ON_OfoN3Z2qf3EQDX75axAQk7M E_s_V5YDKd8XdP.rTYuUiSS5XkdLGQ0PkcabBvRLhX.CNB.ex1sFjWDJspHYxWKJEyxu3c885Mrf vq_b9rQVhXiif5Ga9ozOhXAUyAE1hEfFUeieTuSrAEEzojYlj.Qm2K7X9dnIMz3RlEAs6fqlctOE sO5tTNfN7WQJUnBYI7s.miv1wTibVWiL1xcpyt.hODKHbINcdZcP5cVtwj8.kd4ETGSH9DXj2Vnc cygT4P44ZZQgK_TBt4wnuBfo7pc0n7vN1Lensu7gRYc8MgueFmpPYTxFl9h4KSxjYohY3tw6g18I kxO2ByhMZKIky1xUALEXZZQH_3bRSDAeua.Vj6FQUlRYYH.PwMk2Gbqqzvqbn.gbjQc5VK.MO2X. a_pXBTbUFWczBDb6rxBJSGhy2ZP7fyPqgXPTge7d2rp2NWgtkK.YoSzRkceIVz.gI2y9ubkJ4onU rGyzsrwvXBVt0AM.3NGyoZm02M7EABszIqDJFJuaeaW9E8Bm7j_wlfTlB9EZ6JjNsVd.wb2.WtmL LDzkOpGzz51YPcBkHbQVyC1hTW__L..vIvSOGCzyrGtEpAXyqNgHQwkvkupeIJDu7LK8TyKzb3A_ DgtGJ6RP9Iko1IaecyZpVWVi8hmwlX7uyYrsL41cd6fSHxkAVato7tBrjWZ6s2.jWWCrOwJ4EL0c 2cv7iDgp6Nli6rZKBPSzeZKkQth3UnnSSN_pZpDHILOUrkVKwkSgCz1wMR8UnOFcI3T443h7KZfv iuUd49KX3MeHWyNpCl6soTEiX.WqVLlkv1R1NYbVyJhoG5HOB9oE58K2eRL7fbxBgp4N.wDd3STH jf2CccAeuaUKCmQo3nQZ55o8kzETjIPo_AW7ZIGME51SYtL4YtyeO9EuYEQA3RAWFCXm8b05IMGR pzvJA8y9HPghgyD8e9ICdqJ0RFdb9lRd3ddQYwQ0kVldTkA4p8apmyArs4xKrB.vsEEOuDut1CjD h4gJmHCWnCXlp6ld8.Dkr_FXFeN3J4QHKQZxBSclkh4A.YUSPR_chSuaTy8TS3ydrSZjg2CotfF2 4ZdnfDhXDOvoVaw5IK_sWqzPbS1p6leheU2toRnwHHDqkm3xlG5NNb6GKaRYVq_EM2XiAiG5Idns UDbMH7y.qZxegRCwsTgjFwuQrhyWN5GuxBR0joVAcVbaCsnuDvwta8NCsKtjf_SEl00yqLgCiOEz pZd6SfOB42PK9nqWWce5M8qOSJrn9BMBGxT7yRycOkK5ScabcvIT4yyfY4_kbdYN7oFQGuclZsgs bLL4n X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic310.consmr.mail.gq1.yahoo.com with HTTP; Thu, 17 Nov 2022 19:05:59 +0000 Date: Thu, 17 Nov 2022 19:05:22 +0000 (UTC) From: Boboc Cristi Reply-To: Boboc Cristi To: "David G. Johnston" Cc: "pgsql-docs@lists.postgresql.org" , Alvaro Herrera , Kirk Parker Message-ID: <375196813.1374739.1668711922900@mail.yahoo.com> In-Reply-To: References: <166870559096.639.9180457099983661630@wrigleys.postgresql.org> <20221117174737.w7jhwzarwmudolue@alvherre.pgsql> <1970449059.1357827.1668709232468@mail.yahoo.com> Subject: Re: Merge statement MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1374738_1345254420.1668711922898" X-Mailer: WebService/1.1.20863 YMailNorrin Content-Length: 6047 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_1374738_1345254420.1668711922898 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I agree that your statement is true, but it is still not quite self suffici= ent. For the time being I have no idea how to make it easier to be understood. A= s I have said, for me it is a little confusing. I would pay attention to=C2=A0Kirk Parker=C2=A0=C2=A0idea= : when_clause [ when_clause [...]] to indicate repetitions without commas a= nd xyz [, xyz[, ...]] to indicate repetitions that require commas. I'll be back if some worthy idea will hit my mind. Best regards, Cristi Boboc=20 On Thursday, November 17, 2022 at 08:48:19 PM GMT+2, David G. Johnston = wrote: =20 =20 On Thu, Nov 17, 2022 at 11:20 AM Boboc Cristi wrote: 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. That isn't how that works.=C2=A0 The former means you don't have to add a c= omma between each of the multiples, the later means you do. David J. =20 ------=_Part_1374738_1345254420.1668711922898 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I agree that your statement is true, but i= t is still not quite self sufficient.

For the time being = I have no idea how to make it easier to be understood. As I have said, for = me it is a little confusing.
I would pay attention to&nbs= p;Kirk Parker idea:= when_clause [ when_clause [...]] to indicate repetitions without commas an= d xyz [, xyz[, ...]] to indicate repetitions that require commas.
<= div>
I'll be back if some worthy idea will hit my mind.

Best regards, Cristi Boboc


=20
=20
On Thursday, November 17, 2022 at 08:48:19 PM GMT+2, Da= vid G. Johnston <david.g.johnston@gmail.com> wrote:


On Thu, Nov 17, 202= 2 at 11:20 AM Boboc Cristi <bobocc@yahoo.com> wrote:
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 att= ention, since [...] may indicate "anything", while [,...] are more likely t= o indicate a specific thing that may be repeated.


That isn't how that works.  The former= means you don't have to add a comma between each of the multiples, the lat= er means you do.

David J.
------=_Part_1374738_1345254420.1668711922898--