Re: Very weird problem of "order by" in postgresql - Mailing list pgsql-general

From Peter Cai
Subject Re: Very weird problem of "order by" in postgresql
Date
Msg-id befee6d80809081804k67f6062dre1a21410f89df4f7@mail.gmail.com
Whole thread Raw
In response to Re: Very weird problem of "order by" in postgresql  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Very weird problem of "order by" in postgresql  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Oh, you are right!  Although the 'locale' command show that the 2 has the same locale settings.
The sort result of the same file is different.
Ubuntu is right, centos is wrong……

Maybe I should as this question on some Linux mail lists or forums.

Thanks a lot!

On Mon, Sep 8, 2008 at 8:34 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Peter Cai" <newptcai@gmail.com> writes:
> The only difference is that one OS is centos and the other is ubuntu

It's hardly impossible that those two contain different locale
definitions.  Have you tried comparing the results of sort(1)
under the same locale settings?

                       regards, tom lane



--
科幻小说可能在哲学上是天真的,在道德上是简单的,在美学上是有些主观的,或粗糙的,但是就它最好的方面而言,它似乎触及了人类集体梦想的神经中枢,解放出我们人类这具机器中深藏的某些幻想。

pgsql-general by date:

Previous
From: "Darren Weber"
Date:
Subject: OS X library path issues for libpq (ver 8.3)
Next
From: joe speigle
Date:
Subject: Re: ERROR: cache lookup failed for relation