Re: BUG #1082: Order by doesn't sort correctly.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: rn214(at)cam(dot)ac(dot)uk
Cc: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #1082: Order by doesn't sort correctly.
Date: 2004-02-21 22:47:47
Message-ID: 13563.1077403667@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> writes:
> Description: Order by doesn't sort correctly.

It almost certainly is the correct sort order according to the locale
you're using. Use pg_controldata to check the database locale. You'll
probably want to re-initdb in C locale. Most non-C locales have weird
rules that try to approximate dictionary sort order.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Richard Neill 2004-02-21 23:17:33 Re: BUG #1082: Order by doesn't sort correctly.
Previous Message Scott Goodwin 2004-02-21 19:53:58 Re: Mac OS X, PostgreSQL, PL/Tcl