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: (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group