Re: Add CASEFOLD() function.

Jeff Davis <pgsql@j-davis.com>

From: Jeff Davis <pgsql@j-davis.com>

To: Joe Conway <mail@joeconway.com>, Ian Lawrence Barwick <barwick@gmail.com>

Cc: pgsql-hackers@postgresql.org, Peter Eisentraut <peter@eisentraut.org>, Vik Fearing <vik@postgresfriends.org>

Date: 2024-12-18T18:40:06Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Fix PDF doc build.
- d2ca16bb509c 18.0 landed
Add SQL function CASEFOLD().
- bfc5992069cf 18.0 landed
Add support for Unicode case folding.
- 4e7f62bc386a 18.0 landed

On Mon, 2024-12-16 at 16:27 -0500, Joe Conway wrote:
> 
> SQL 2023 seems to include the NORMALIZE syntax, but the only case 
> folding considered is UPPER and LOWER. As such, I think it ought to
> be a 
> function but not part of the grammar.

Should the standard support something like the Unicode idea of case
folding? If so, do we need to be careful of conflicts?

Regards,
	Jeff Davis