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.
