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

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?

If someone opts into a collation (and surely a non-deterministic
collation would be opt-in), then I think it makes sense that they
accept some performance costs and dependency versioning risks for the
functionality.

My point still stands that all deterministic collations are, at least
for equality, identical.

Regards,
    Jeff Davis