Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uF2MW-00GgRV-9c for pgsql-hackers@arkaria.postgresql.org; Wed, 14 May 2025 03:00:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uF2MV-007yR8-Bg for pgsql-hackers@arkaria.postgresql.org; Wed, 14 May 2025 03:00:51 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uF2MU-007yR0-MG for pgsql-hackers@lists.postgresql.org; Wed, 14 May 2025 03:00:51 +0000 Received: from fhigh-a3-smtp.messagingengine.com ([103.168.172.154]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uF2MR-001gq8-3B for pgsql-hackers@lists.postgresql.org; Wed, 14 May 2025 03:00:49 +0000 Received: from phl-compute-03.internal (phl-compute-03.phl.internal [10.202.2.43]) by mailfhigh.phl.internal (Postfix) with ESMTP id EBCB1114013A; Tue, 13 May 2025 23:00:46 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-03.internal (MEProxy); Tue, 13 May 2025 23:00:46 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=justatheory.com; h=cc:cc:content-type:content-type:date:date:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to; s=fm3; t=1747191646; x= 1747278046; bh=IMUsdaTrfvJ3p8Bncpyfbnrr4BgswpHDL+OjbPomYWc=; b=Z wkpoZqxcg7npV0MBUJUVh4hXbMusNKbsQZ+uiFsijr/1ajsp664IgoQ2fmykkqWs rMmxMf/Tg11o3zeitz80j2sszTJ92jT7+asWUdJINqYOsIsn3CUqJHO4+Vrr3d3j y1M/ZOKoLbTAN4BDVAlgAmA2RWAA1tc/QeQ57dRP8WhD7FULx2d2hHONQAbWqUyD 2f3RGSVKiMXPmgMc5CqwcJXPVw75Ov+HY3wcqH93+iBY4JvuPuvidK3AssDVuN7V K6uq/H7D5d63Wg10nNNcmFIzksZfIg/mTh67m4gKouvR0kheZBwRB3jq813h4a9N IdX7U9JkmUbKCanBJuPrQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t= 1747191646; x=1747278046; bh=IMUsdaTrfvJ3p8Bncpyfbnrr4BgswpHDL+O jbPomYWc=; b=gmgHvHEZlnaScWgT0VqTTRjszmLVICIrRvl1iBYveFt0hflsNtl A9YLq1BtjGOM8DNutK9uf2bQrpHU57VuCvhhAsh3v/dWVpp3XAAmByr8GhJ7v0eG olAOVbOjJyNV1+Bu7O2b799DXwKiAKMcftAFI48egu2tm/Rn1OhoTBJ8V9BsqgDb sBnbFlq7SLd5aqHHo8b6Rufqzt3PClBR6d1SnHHG2796UzbAK7gTX8h8WmGUmNq/ vuMcz72BTH7nN7w66oHr/8w6s/jLs5QZ+TJn/Yvkqk9HRAP32kGebfK78PNKgD3J oF7Tc4/RI8eWoIUPbBzsCJ2xIMbgtviaC+A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgdeftdehkeehucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggv pdfurfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpih gvnhhtshculddquddttddmnecujfgurheptggguffhjgffvefkfhfvofesghdtmherhhdt jeenucfhrhhomhepfdffrghvihguucfgrdcuhghhvggvlhgvrhdfuceouggrvhhiugesjh hushhtrghthhgvohhrhidrtghomheqnecuggftrfgrthhtvghrnhephffhieeitdefkeev hfehtdfgieehgfffleetjeetkeeitdeugeejgeefffffkeeinecuvehluhhsthgvrhfuih iivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepuggrvhhiugesjhhushhtrghthhgv ohhrhidrtghomhdpnhgspghrtghpthhtohepjedpmhhouggvpehsmhhtphhouhhtpdhrtg hpthhtohepfhhlohhrvghnthhsrdhtshgvlhgrihesghhmrghilhdrtghomhdprhgtphht thhopehrohgsvghrthhmhhgrrghssehgmhgrihhlrdgtohhmpdhrtghpthhtoheprggvkh horhhothhkohhvsehgmhgrihhlrdgtohhmpdhrtghpthhtohepthhglhesshhsshdrphhg hhdrphgrrdhushdprhgtphhtthhopehpghhsqhhlqdhhrggtkhgvrhhssehlihhsthhsrd hpohhsthhgrhgvshhqlhdrohhrghdprhgtphhtthhopegrnhgurhgvfiesughunhhslhgr nhgvrdhnvghtpdhrtghpthhtohepphgvthgvrhesvghishgvnhhtrhgruhhtrdhorhhg X-ME-Proxy: Feedback-ID: i7c334307:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 13 May 2025 23:00:45 -0400 (EDT) Content-Type: multipart/signed; boundary="Apple-Mail=_C82EA5B2-784D-4E43-BE8D-4DB4D3FC40F7"; protocol="application/pgp-signature"; micalg=pgp-sha256 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.500.181.1.5\)) Subject: Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part From: "David E. Wheeler" In-Reply-To: <3682F2FE-AB57-4799-A439-7DA518E978A4@gmail.com> Date: Tue, 13 May 2025 23:00:34 -0400 Cc: Robert Haas , Alexander Korotkov , Tom Lane , pgsql-hackers , Andrew Dunstan , Peter Eisentraut Message-Id: References: <145894.1727298237@sss.pgh.pa.us> <88A95900-E976-43BE-A73A-45AA75A11EE7@justatheory.com> <3682F2FE-AB57-4799-A439-7DA518E978A4@gmail.com> To: Florents Tselai X-Mailer: Apple Mail (2.3826.500.181.1.5) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail=_C82EA5B2-784D-4E43-BE8D-4DB4D3FC40F7 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 On May 13, 2025, at 16:24, Florents Tselai = wrote: > As Robert said=E2=80=94and I agree=E2=80=94renaming the existing _tz = family would be more trouble than it=E2=80=99s worth, given the need for = deprecations, migration paths, etc. If we were designing this today, = suffixes like _stable or _volatile might have been more appropriate, but = at this point, we=E2=80=99re better off staying consistent with the _tz = family. I get the pragmatism, and don=E2=80=99t want to over-bike-shed, but what = a wart to live with. [I just went back and re-read Robert=E2=80=99s = post, and didn=E2=80=99t realize he used exactly the same expression!] = Would it really be too effortful to create _stable or _volatile = functions and leave the _tz functions as a sort of legacy? Or maybe there=E2=80=99s a nice backronym we could come up with for _tz.=20= Best, David --Apple-Mail=_C82EA5B2-784D-4E43-BE8D-4DB4D3FC40F7 Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename=signature.asc Content-Type: application/pgp-signature; name=signature.asc Content-Description: Message signed with OpenPGP -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEEd+KfmbOQis6ZycGGkt9idPjIgfEFAmgkB1IACgkQkt9idPjI gfEIDQ/+Ohx/1VL+cg1LPRzMHofoD3L3qXgwQDkyzE9eiDjkZync5T4f1tt0VIoW 3wg2lWzgb5IzOmhdadssvxI+feGTClZdjX98f9ELkQaeIA1drc8m/BMj0MiZf4fb YA8ynIOuXPB2Mmjj4Q6UNN3lR0vXi2QslDSK+jg0JLsc8apgWVCFyNhh5g5Pog8D a2OPeB07Ipv7Xi4fn84PjgmYmwgPWgQo5xkfBizQNZ8/H/t7CcHISeCpOmV7v5vs z5KxcznIHdA8kFJu0frfdbijz+KKMXCASXaLmP+i5pCRkaqrLQ8ZbdEq+3pTn72Y WEPRe4I53vyBvROO6dEzrKLQSucyRW8OZLXB2muXBRiq09VfIEFn2u0LLoslTi0y a++7HR4mHXsslFCTHHd54uaRPhAlstdAZWYYO91G+iusxDAjJWXWXsn8dXpOhY4B 2pOCjIlSss5KP+c7BOPCxYVN/r6BYlvbipaDMknLGG/YUINEosMipWPiTFi3ggGu 9ezv4RzcvmsntxIS1E5IIPGX588lwAsylrePbtQ0DAPGJ4Iizqy2LCBuDVcyGPS1 WPzF+gpPBNhZsFQyt4tg8C2MDg6frhzNP1/7GhL7lAE78DbOEsKN3yjXe4476v/5 8qtf5Ockv4Ss3DhQU8L9U+/tbV77idTVjBlMhR7203YgJenKoCM= =T0KF -----END PGP SIGNATURE----- --Apple-Mail=_C82EA5B2-784D-4E43-BE8D-4DB4D3FC40F7--