Re: [HACKERS] How can I find a specific collation in pg_collation when using ICU?

2017-08-09 Thread Tom Lane
Peter Geoghegan writes: > On Wed, Aug 9, 2017 at 6:19 PM, Tsunakawa, Takayuki > wrote: >> That's sad news, as I expected ICU to bring its various collation features >> to PostgreSQL. I hope it will be easy to add them. > The reason it is not easy is that text equality is based on strict > bina

Re: [HACKERS] How can I find a specific collation in pg_collation when using ICU?

2017-08-09 Thread Peter Geoghegan
On Wed, Aug 9, 2017 at 6:19 PM, Tsunakawa, Takayuki wrote: > From: pgsql-hackers-ow...@postgresql.org >> [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Peter Eisentraut >> There are no case-insensitive collations in PostgreSQL (yet). > > That's sad news, as I expected ICU to bring its va

Re: [HACKERS] How can I find a specific collation in pg_collation when using ICU?

2017-08-09 Thread Tsunakawa, Takayuki
From: pgsql-hackers-ow...@postgresql.org > [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Peter Eisentraut > There are no case-insensitive collations in PostgreSQL (yet). That's sad news, as I expected ICU to bring its various collation features to PostgreSQL. I hope it will be easy to

Re: [HACKERS] How can I find a specific collation in pg_collation when using ICU?

2017-08-09 Thread Peter Geoghegan
On Wed, Aug 9, 2017 at 5:38 AM, MauMau wrote: > I tried to find a particular collation name in pg_collation, but I > cannot understand the naming convention after reading the following > article. Specifically, I want to find out whether there is some > collation equivalent to Japanese_CI_AS in SQ

Re: [HACKERS] How can I find a specific collation in pg_collation when using ICU?

2017-08-09 Thread Peter Eisentraut
On 8/9/17 08:38, MauMau wrote: > I tried to find a particular collation name in pg_collation, but I > cannot understand the naming convention after reading the following > article. Specifically, I want to find out whether there is some > collation equivalent to Japanese_CI_AS in SQL Server, which