On 13.11.23 17:49, Jeff Davis wrote:
> On Mon, 2023-11-13 at 13:43 +0100, Peter Eisentraut wrote:
>> On 11.11.23 01:03, Jeff Davis wrote:
>>> But the database collation is always deterministic,
>>
>> So far!
>
> Yeah, if we did that, clearly the index collation would need to match
> that of the database to be useful. What are the main challenges in
> allowing non-deterministic collations at the database level?
Text pattern matching operations (LIKE, ~) don't work.
"Allowing" here is the right word. We could enable it, and it would
work just fine, but because of the restriction I mentioned, the
experience would not be very pleasant.
