Re: help understanding collation order

From: raf <raf(at)raf(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: help understanding collation order
Date: 2011-01-19 02:34:43
Message-ID: 20110119023443.GA25805@raf.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ozz Nixon 2011-01-19 03:06:07 Another table/column has semi-current COUNTs?
Previous Message Alban Hertroys 2011-01-19 00:04:02 Re: Getting a sample data set.