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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general