Re: Add CASEFOLD() function.

Jeff Davis <pgsql@j-davis.com>

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

To: Thom Brown <thom@linux.com>

Cc: Vik Fearing <vik@postgresfriends.org>, Joe Conway <mail@joeconway.com>, Ian Lawrence Barwick <barwick@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>, Peter Eisentraut <peter@eisentraut.org>

Date: 2025-06-19T04:26:23Z

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 Thu, 2025-06-19 at 05:03 +0100, Thom Brown wrote:
> Late to the party, but is there an argument for porting this to the
> citext type? Or supplementing the extension with an additional type
> ("cftext"? *shrug*).

CASEFOLD() addresses a lot of the problems with using LOWER(), so that
sounds like a good idea. I'd be interested to hear from users of
citext.

Regards,
	Jeff Davis