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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] How can I find a specific collation in pg_collation when using ICU?
Дата
Msg-id 18006.1502330379@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] How can I find a specific collation in pg_collationwhen using ICU?  (Peter Geoghegan <pg@bowt.ie>)
Список 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 по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: [HACKERS] How can I find a specific collation in pg_collationwhen using ICU?
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: [HACKERS] Causal reads take II