| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Peter Geoghegan <pg(at)bowt(dot)ie> |
| Cc: | "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, "maumau307(at)gmail(dot)com" <maumau307(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: How can I find a specific collation in pg_collation when using ICU? |
| Date: | 2017-08-10 01:59:39 |
| Message-ID: | 18006.1502330379@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Peter Geoghegan <pg(at)bowt(dot)ie> writes:
> On Wed, Aug 9, 2017 at 6:19 PM, Tsunakawa, Takayuki
> <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)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 add them.
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Munro | 2017-08-10 02:02:57 | Re: Causal reads take II |
| Previous Message | Peter Geoghegan | 2017-08-10 01:43:45 | Re: How can I find a specific collation in pg_collation when using ICU? |