Re: Order by and leading spaces

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Order by and leading spaces
Дата
Msg-id 20030706103445.V59736-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на Order by and leading spaces  ("Emmanuel GUYOT - InCrEG" <emmguyot@wanadoo.fr>)
Список pgsql-bugs
On Sun, 6 Jul 2003, Emmanuel GUYOT - InCrEG wrote:

> I've noticed that the 7.3.3 has a strange behaviour were sorting rows
> with leading spaces. It seems that leadings spaces are ignored.

Are you in "C" locale or some other locale and on what OS?  Some (many?)
OS locale definitions have collation rules that ignore spaces and/or
symbols.  For example, on my redhat box in en_US locale, " b" > "a".

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

Предыдущее
От: "Emmanuel GUYOT - InCrEG"
Дата:
Сообщение: Order by and leading spaces
Следующее
От: Shachar Shemesh
Дата:
Сообщение: case sensitivity