Re: Very weird problem of "order by" in postgresql

["Peter Cai" <newptcai@xxxxxxxxx>]

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@xxxxxxxxxxxxx> wrote:

"Peter Cai" <newptcai@xxxxxxxxx> 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

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