Postgres Pro
Downloads
Home   >   mailing lists

Re: Collation in ORDER BY not lexicographical - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Collation in ORDER BY not lexicographical
Date
Msg-id dcc563d10909290221p72dc2b08m6398c2cd5c20dcc9@mail.gmail.com
Whole thread Raw
In response to Collation in ORDER BY not lexicographical  (Paul Gaspar <devlist@revolversoft.com>)
Responses Re: Collation in ORDER BY not lexicographical  (Maximilian Tyrtania <maximilian.tyrtania@onlinehome.de>)
Re: Collation in ORDER BY not lexicographical  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Tree view 
On Tue, Sep 29, 2009 at 2:52 AM, Paul Gaspar <devlist@revolversoft.com> wrote:
> Hi!
>
> We have big problems with collation in ORDER BY, which happens in binary
> order, not alphabetic (lexicographical), like:.
>
> A
> B
> Z
> a
> z
> Ä
> Ö
> ä
> ö
>

> PG is running on Mac OS X 10.5 and 10.6 Intel.

I seem to recall there were some problem with Mac locales at some
point being broken.  Could be you're running into that issue.

pgsql-general by date:

Previous
From: Paul Gaspar
Date:
Subject: Collation in ORDER BY not lexicographical
Next
From: InterRob
Date:
Subject: WITH SELECT * FROM function(
) WHERE etc