Re: [HACKERS] How can I find a specific collation in pg_collation when using ICU? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] How can I find a specific collation in pg_collation when using ICU?
Date
Msg-id 18006.1502330379@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] How can I find a specific collation in pg_collationwhen using ICU?  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-hackers
Peter Geoghegan <pg@bowt.ie> writes:
> On Wed, Aug 9, 2017 at 6:19 PM, Tsunakawa, Takayuki
> <tsunakawa.takay@jp.fujitsu.com> wrote:
>> That's sad news, as I expected ICU to bring its various collation features to PostgreSQL.  I hope it will be easy to
addthem. 

> The reason it is not easy is that text equality is based on strict
> binary equality.

Yeah.  You can change sort order all you want, but you can't easily
change the system's notion of equality.  But when people ask for "case
insensitive" collation, they generally want that too.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: [HACKERS] How can I find a specific collation in pg_collationwhen using ICU?
Next
From: Thomas Munro
Date:
Subject: Re: [HACKERS] Causal reads take II