Re: Support regular expressions with nondeterministic collations

Peter Eisentraut <peter@eisentraut.org> writes:
> On 22.10.24 16:40, Tom Lane wrote:
>> Peter Eisentraut <peter@eisentraut.org> writes:
>>> In summary, this patch doesn't change any functionality that currently
>>> works.  It just removes one error message and lets regular expressions
>>> just run, independent of whether the collation is nondeterministic.

>> I kind of wonder if we really want to do this.  It adds no
>> functionality, and it forecloses the possibility of changing
>> the definition later.

> Btw., one end goal here is to be able to run with a nondeterministic 
> collation as the global locale.  So for example you could make the whole 
> system insensitive to Unicode normalization forms.  But if that 
> effectively globally disables regular expressions, then people will be 
> sad, and also most of psql breaks, and so on.  So some positive solution 
> here would be useful.

Sure, and I'll support this patch once we're sure that no better
functionality is possible.  I just want to look into whether the
SQL committee knows something we don't.

            regards, tom lane