order by differences: locale problem?

Поиск
Список
Период
Сортировка
От Raphael Bauduin
Тема order by differences: locale problem?
Дата
Msg-id f5227160901150329i10feb549v344ef3959c3bb5f2@mail.gmail.com
обсуждение исходный текст
Ответы Re: order by differences: locale problem?
Список pgsql-novice
Hi,

I have ordering differences between 2 servers, running both the same
linux distribution (debian), the same postgresql server (8.2.9, though
one was compiled, and the order installed with debian packages).
Both have differences in ordering, and I don't know which settings
influence this behaviour:

Here's an example:

Server 1: expected behaviour:

select 'About' as n union select 'arrow' as n union select 'Bold' as n
union select 'sequence' as n order by n;
    n
----------
 About
 Bold
 arrow
 sequence



Server 2:  undesired behaviour: it sorts results case unsensitive

select 'About' as n union select 'arrow' as n union select 'Bold' as n
union select 'sequence' as n order by n;
    n
----------
 About
 arrow
 Bold
 sequence


What settings do I have to change to have the same behaviour on both servers?

Thanks in advance.

Raphaël


--
Web database: http://www.myowndb.com
Free Software Developers Meeting: http://www.fosdem.org

В списке pgsql-novice по дате отправления:

Предыдущее
От: John DeSoi
Дата:
Сообщение: Re: function transaction scope question
Следующее
От: "Wright, George"
Дата:
Сообщение: Re: function transaction scope question