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 по дате отправления: