Re: Collation in ORDER BY not lexicographical

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Paul Gaspar <devlist(at)revolversoft(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Collation in ORDER BY not lexicographical
Date: 2009-09-29 09:21:24
Message-ID: dcc563d10909290221p72dc2b08m6398c2cd5c20dcc9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Sep 29, 2009 at 2:52 AM, Paul Gaspar <devlist(at)revolversoft(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message InterRob 2009-09-29 10:00:19 WITH <table> SELECT * FROM function(<table>) WHERE etc
Previous Message Paul Gaspar 2009-09-29 08:52:02 Collation in ORDER BY not lexicographical