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

Поиск
Список
Период
Сортировка
От Peter Cai
Тема Re: Very weird problem of "order by" in postgresql
Дата
Msg-id befee6d80809081804k67f6062dre1a21410f89df4f7@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Very weird problem of "order by" in postgresql  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Very weird problem of "order by" in postgresql  (Martijn van Oosterhout <kleptog@svana.org>)
Список 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 по дате отправления:

Предыдущее
От: "Darren Weber"
Дата:
Сообщение: OS X library path issues for libpq (ver 8.3)
Следующее
От: joe speigle
Дата:
Сообщение: Re: ERROR: cache lookup failed for relation