Message-ID: <7288394fff1c354f6bda8918d64840595bab0477.camel@j-davis.com>
Subject: Re: Add CASEFOLD() function.
From: Jeff Davis <pgsql@j-davis.com>
To: Vik Fearing <vik@postgresfriends.org>, Peter Eisentraut
 <peter@eisentraut.org>, Joe Conway <mail@joeconway.com>, Ian Lawrence
 Barwick <barwick@gmail.com>
Cc: pgsql-hackers@postgresql.org
Date: Thu, 19 Jun 2025 09:52:47 -0700
In-Reply-To: <7ee0ad52-650b-472f-82f4-27d2cf1a0887@postgresfriends.org>
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>
	 <3e0eaadb-8a1a-49de-8037-3c9123f99031@eisentraut.org>
	 <7ee0ad52-650b-472f-82f4-27d2cf1a0887@postgresfriends.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.52.3-0ubuntu1 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/7288394fff1c354f6bda8918d64840595bab0477.camel%40j-davis.com>
Precedence: bulk

On Thu, 2025-06-19 at 18:21 +0200, Vik Fearing wrote:
> >=20
> > The SQL standard also says in a few other places that normalization
> > should be applied, and we do none of those, so this is probably not
> > a=20
> > reason to change CASEFOLD at this point.
> >=20
>=20
> Works for me.

Sounds good. We can document compatibility notes around this point.

If normalization becomes important, we can take the time to work out
the performance implications more carefully, and potentially introduce
an NCASEFOLD() if needed.

Regards,
	Jeff Davis