Re: Why do indexes and sorts use the database collation?

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.