Re: Character expansion with ICU collations

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>
Cc: "Finnerty, Jim" <jfinnert(at)amazon(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Character expansion with ICU collations
Date: 2021-06-09 17:58:08
Message-ID: 1424195.1623261488@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com> writes:
> You can have these queries return both rows if you use an
> accent-ignoring collation, like this example in the documentation:

> CREATE COLLATION ignore_accents (provider = icu, locale =
> 'und-u-ks-level1-kc-true', deterministic = false);

It occurs to me to wonder whether texteq() still obeys transitivity
when using such a collation.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jonathan S. Katz 2021-06-09 18:33:56 unnesting multirange data types
Previous Message Peter Eisentraut 2021-06-09 17:54:54 Re: Character expansion with ICU collations