On Tue, Sep 29, 2009 at 2:52 AM, Paul Gaspar <devlist(at)revolversoft(dot)com> wrote:
> We have big problems with collation in ORDER BY, which happens in binary
> order, not alphabetic (lexicographical), like:.
> 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: InterRob||Date: 2009-09-29 10:00:19|
|Subject: WITH <table> SELECT * FROM function(<table>) WHERE etc|
|Previous:||From: Paul Gaspar||Date: 2009-09-29 08:52:02|
|Subject: Collation in ORDER BY not lexicographical|