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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Peter Cai" <newptcai(at)gmail(dot)com>
Cc: "Justin Graf" <justin(at)emproshunts(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Very weird problem of "order by" in postgresql
Date: 2008-09-08 12:34:51
Message-ID: 12746.1220877291@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Peter Cai" <newptcai(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message joe speigle 2008-09-08 12:54:36 ERROR: cache lookup failed for relation
Previous Message Devrim GÜNDÜZ 2008-09-08 11:28:29 Re: [HACKERS] New shapshot RPMs (Sep 7 2008) are ready for testing