Re: insensitive collations

Поиск
Список
Период
Сортировка
Искать
От
Daniel Verite
Тема
Re: insensitive collations
Дата
Msg-id
02431ac1-37c0-4a06-86e1-bf6cf27881f3@manitou-mail.org
Ответ на
Re: insensitive collations (Peter Eisentraut)
Список
Дерево обсуждения
insensitive collations Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: insensitive collations "Daniel Verite" <daniel@manitou-mail.org>
Re: insensitive collations Tom Lane <tgl@sss.pgh.pa.us>
Re: insensitive collations "Daniel Verite" <daniel@manitou-mail.org>
Re: insensitive collations Peter Geoghegan <pg@bowt.ie>
Re: insensitive collations Tom Lane <tgl@sss.pgh.pa.us>
Re: insensitive collations Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: insensitive collations "Daniel Verite" <daniel@manitou-mail.org>
Re: insensitive collations Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: insensitive collations "Daniel Verite" <daniel@manitou-mail.org>
Re: insensitive collations Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: insensitive collations Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: insensitive collations "Daniel Verite" <daniel@manitou-mail.org>
Re: insensitive collations Jim Finnerty <jfinnert@amazon.com>
Re: insensitive collations Jim Finnerty <jfinnert@amazon.com>
Re: insensitive collations "Daniel Verite" <daniel@manitou-mail.org>
Re: insensitive collations Jim Finnerty <jfinnert@amazon.com>
Re: insensitive collations Jim Finnerty <jfinnert@amazon.com>
Re: insensitive collations "Daniel Verite" <daniel@manitou-mail.org>
Re: insensitive collations Jim Finnerty <jfinnert@amazon.com>
Re: insensitive collations "Daniel Verite" <daniel@manitou-mail.org>
Re: insensitive collations Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: insensitive collations Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: insensitive collations Peter Geoghegan <pg@bowt.ie>
Re: insensitive collations Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: insensitive collations Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: insensitive collations "Daniel Verite" <daniel@manitou-mail.org>
Re: insensitive collations Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: insensitive collations "Daniel Verite" <daniel@manitou-mail.org>
Re: insensitive collations Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: insensitive collations Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: insensitive collations Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: insensitive collations Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: insensitive collations "Daniel Verite" <daniel@manitou-mail.org>
Re: insensitive collations Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: insensitive collations Andreas Karlsson <andreas@proxel.se>
Re: insensitive collations Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: insensitive collations Andreas Karlsson <andreas@proxel.se>
Re: insensitive collations Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: insensitive collations "Daniel Verite" <daniel@manitou-mail.org>
Re: insensitive collations "Daniel Verite" <daniel@manitou-mail.org>
Re: insensitive collations Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: insensitive collations "Daniel Verite" <daniel@manitou-mail.org>
Re: insensitive collations Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
	Peter Eisentraut wrote:

> Older ICU versions (<54) don't support all the locale customization
> options, so many of my new tests in collate.icu.utf8.sql will fail on
> older systems.  What should we do about that?  Have another extra test file?

Maybe stick to the old-style syntax for the regression tests?
The declarations that won't work as expected with older ICU versions
would be:

CREATE COLLATION case_insensitive (provider = icu, locale =
'und-u-ks-level2', deterministic = false);

'und-u-ks-level2' is equivalent to 'und@colStrength=secondary'

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

'und-u-ks-level1-kc-true' => 'und@colStrength=primary;colCaseLevel=yes'


Best regards,
-- 
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite

В списке pgsql-hackers по дате отправления
От: Pavel Stehule
Дата:
От: Andres Freund
Дата:
FAQ