Re: order by query wrong result

Поиск
Список
Период
Сортировка
От Matheus de Oliveira
Тема Re: order by query wrong result
Дата
Msg-id CAJghg4+r4WRsGM_K0G6swXaKCMdRMN-QXu7hsM6aHx0112q-5A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: order by query wrong result  (Scott Ribe <scott_ribe@elevated-dev.com>)
Ответы Re: order by query wrong result
Список pgsql-admin

On Wed, Nov 19, 2014 at 12:34 PM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
Yes, I know. On my first attempt I couldn't imagine any reasonable rule which would result in that order. But on a second try, I see one...


If you ignore dots, spaces, and dashs, you have that result. Looks like it is what your collate is doing (and possible ignoring other characters).

Regards,
--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres

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

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: order by query wrong result
Следующее
От: Scott Ribe
Дата:
Сообщение: Re: order by query wrong result