Feedback-ID: i7c334307:Fastmail
Content-Type: multipart/signed;
	boundary="Apple-Mail=_7FB15B58-C239-4B04-A2DD-494DC46207A3";
	protocol="application/pgp-signature";
	micalg=pgp-sha256
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.600.51.1.1\))
Subject: Re: Add CASEFOLD() function.
From: "David E. Wheeler" <david@justatheory.com>
In-Reply-To: 
 <CAA-aLv5Se9zt3CxcGWYwJUA-0nnx+sAArwUWRJKTwTL1a=8YyA@mail.gmail.com>
Date: Thu, 19 Jun 2025 13:38:54 -0400
Cc: Jeff Davis <pgsql@j-davis.com>,
 Peter Eisentraut <peter@eisentraut.org>,
 Vik Fearing <vik@postgresfriends.org>,
 Joe Conway <mail@joeconway.com>,
 Ian Lawrence Barwick <barwick@gmail.com>,
 PostgreSQL-development <pgsql-hackers@postgresql.org>
Message-Id: <81AFE376-ACFE-4F78-A33B-9B5F2339FDA7@justatheory.com>
References: <a1886ddfcd8f60cb3e905c93009b646b4cfb74c5.camel@j-davis.com>
 <CAB8KJ=jgnpbDTJS+jOQMzo7b1mPTwM0hCqQBBRgoX_kvyxWVog@mail.gmail.com>
 <ab1bdabcf64d799692ddaa5b06b5ef8afe94a0ef.camel@j-davis.com>
 <47716a78-eb0b-4728-8991-fc0d958a01c9@joeconway.com>
 <c3801da038f8f59ee63deb9104af1147d49454c8.camel@j-davis.com>
 <36f69fa9-db3f-44a1-8c8a-95ff09704a9c@postgresfriends.org>
 <af6b575335ffeea36db3189fe7031adf67c250d2.camel@j-davis.com>
 <692d28a2-d5f8-4db5-a3ad-c7db9bab522f@postgresfriends.org>
 <e26ae6f202aff57a76e14cfb8ba2202550257f27.camel@j-davis.com>
 <CAA-aLv7KLoT9yCdiJwRP9PeL_4yNTzQ3T8WJLbTtX=Ld45UOpg@mail.gmail.com>
 <d230fd82-a285-4768-9b17-9b57ac2ff2a2@eisentraut.org>
 <CAA-aLv57dEeoX__Osx4k2yda6G2V-i=MYxr0HrH6U+yyYw5wKQ@mail.gmail.com>
 <ab9a2b8d25ff826cb785a1d0f21391538ce2aff6.camel@j-davis.com>
 <CAA-aLv5Se9zt3CxcGWYwJUA-0nnx+sAArwUWRJKTwTL1a=8YyA@mail.gmail.com>
To: Thom Brown <thom@linux.com>
Archived-At: 
 <https://www.postgresql.org/message-id/81AFE376-ACFE-4F78-A33B-9B5F2339FDA7%40justatheory.com>
Precedence: bulk


--Apple-Mail=_7FB15B58-C239-4B04-A2DD-494DC46207A3
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8

On Jun 19, 2025, at 12:59, Thom Brown <thom@linux.com> wrote:

> No. But given the options, I would personally choose nondeterministic =
collations now that they are available. I just wish they were more =
user-friendly as I suspect the majority of people either won't know =
about them, or won't know how to use them.

I suspect there are a lot of uses of citext for databases created before =
nondeterministic collations existed and people are unaware of them or =
unclear on the migration path from one to the other, let alone =
implications for any infrastructure they built around cutest (like =
function signatures and return values). As long as citext conteinues to =
be maintained there and there=E2=80=99s no super clear path to migrate, =
I=E2=80=99d bet good money that few would bother to switch.

Best,

David


--Apple-Mail=_7FB15B58-C239-4B04-A2DD-494DC46207A3
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+KfmbOQis6ZycGGkt9idPjIgfEFAmhUSy4ACgkQkt9idPjI
gfEXbQ/8DBHc1PPoJG7bcbQZk7ZA05zQUyK1EWNuyxyVa3xXZJvO3n/rhUVenZoQ
sEfC2aCszetyQEqJ6SHtvYQt6yHGtvIaim0zbS3om+GZue2oqvK0dv+7hYVIgHsm
MtbFkMvZ8v6WBKMzhh4VNpVKg5Ts0O/E4C5QVW2jddSS3BfZu71NKcww8Mxd0QYz
L40VlxAyPs79c0vB9s8SXLuDkfwyNDnH5iJUSFf7Z1Z+t5bHmoPQCgIQ1ayr4l28
UkWdgYKQxW8CxwfpuhxQW950MwO9lF0T7GkMyoJ4pf5XGlZpqqa1DrA9rJ2F+qZa
0UCNGY7PpCvAINsG3pcFhfDMRM6vCQlXthCHVtgtMA+TRTT5b5ABogrj6e+7mgWE
lXDZcUZNXywkAypLCtw5Kct/IarbLF08sROyIvann+Ar94XiTG4CNib2nNGhs3S5
xJYZH7rb4BONm4fkLB5ZkhveIhzIDxFsi4yGjD1Tmiv1z2lYiriZVXth3Fmi561h
FOwuyFru2P8me7ufUISwwNaaCjMd/ju7dGFKW1MpCxaU1+jBNqNUn2SkAFFOrxSQ
m8WFI2FZPG1mV5CVb7Txtt/QSDlVO4O6xnKhIbLdgTTe+PKuGuZcn7jZGEVTb0sD
qZNMuRDgzlTWXD1mwcroEV+6cwzJe85/aGqANstXo8oO4kp/kRo=
=fTdg
-----END PGP SIGNATURE-----

--Apple-Mail=_7FB15B58-C239-4B04-A2DD-494DC46207A3--