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 по дате отправления: