Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group