Re: help understanding collation order

Поиск
Список
Период
Сортировка
От raf
Тема Re: help understanding collation order
Дата
Msg-id 20110119023443.GA25805@raf.org
обсуждение исходный текст
Ответ на Re: help understanding collation order  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: help understanding collation order
Список pgsql-general
Peter Eisentraut wrote:

> On tis, 2011-01-18 at 10:33 +1100, raf wrote:
> > p.s. if anyone in debian locale land is listening,
> > 'E' does not sort before ','. what were you thinking? :-)
>
> What is actually happening is that the punctuation is sorted in a second
> pass after the letters.  Which is both correct according to the relevant
> standards and also practical in many situations.

i have no doubt that what you say is true just as i have no doubt that
it is also incorrect and impractical in every situation i'll ever encounter.
i can't imagine ever wanting CLARK to sort both before and after CLARKE.
i'll just re-sort all name-ordered reports in the client. pity.

> It's usually actually the Mac OS X locales that are broken.

only when ignoring the principle of least astonishment. :-)

but it's not the same locale on the two hosts. the macosx
locale is en_AU. the debian locale is en_AU.utf8 so i don't
think they can be compared for brokenness purposes in this case.
they may both be correct.

cheers,
raf


В списке pgsql-general по дате отправления:

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: Getting a sample data set.
Следующее
От: Ozz Nixon
Дата:
Сообщение: Another table/column has semi-current COUNTs?