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

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

pgsql-bugs by date

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

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