Re: Add CASEFOLD() function.

Andreas Karlsson <andreas@proxel.se>

From: Andreas Karlsson <andreas@proxel.se>

To: Jeff Davis <pgsql@j-davis.com>, pgsql-hackers@postgresql.org

Date: 2024-12-18T01:31:14Z

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 12/12/24 10:00 AM, Jeff Davis wrote:
> Patch attached.

I have not looked at the patch yet but +1 to the idea. I am leaning 
towards that the function also optionally normalizing the codepoints 
would be handy too since I think that is what most usecases want. 
Otherwise people would have to always type normalize(casefold(str)).

Andreas