Re: Support regular expressions with nondeterministic collations

Peter Eisentraut <peter(at)eisentraut(dot)org> writes:
> On 22.10.24 16:40, Tom Lane wrote:
>> Peter Eisentraut <peter(at)eisentraut(dot)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