Re: Add CASEFOLD() function.

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: Thom Brown <thom(at)linux(dot)com>, Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: Vik Fearing <vik(at)postgresfriends(dot)org>, Joe Conway <mail(at)joeconway(dot)com>, Ian Lawrence Barwick <barwick(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Add CASEFOLD() function.
Date: 2025-06-19 14:51:02
Message-ID: d230fd82-a285-4768-9b17-9b57ac2ff2a2@eisentraut.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 19.06.25 06:03, 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*). It currently uses lower(), so our current
> recommendation for dealing with all unicode characters is to use
> nondeterministic collations.

What is the motivation for wanting a citext variant instead of using
nondeterministic collations?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Aleksander Alekseev 2025-06-19 14:51:36 [PATCH] pg_bsd_indent: improve formatting of multiline comments
Previous Message Peter Eisentraut 2025-06-19 14:47:10 Re: Add CASEFOLD() function.