How to obtain a good ASCII order ?

Поиск
Список
Период
Сортировка
От eurlix
Тема How to obtain a good ASCII order ?
Дата
Msg-id 20030528213821.2490c707.eurlix@libertysurf.fr
обсуждение исходный текст
Список pgsql-novice
Hello all,

It seem to me that when a column contain non current characters
like "*" (052, X2A), ">" (076, X3E), etc ... pg gives it in a
non-ASCII ordered sequence.

When I know that some character may be appear volontary in the
first position of the column, I have found that I can have a good
result (for me) by "... order by substr(col,1,1), col ...) but
when I cannot presume this, how may I have a good sequence ?

Thanks,
--
Alain Lucari (Eurlix)

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

Предыдущее
От: papapep
Дата:
Сообщение: Re: Inserting data of two other tables [Now deleting ...]
Следующее
От: Nabil Sayegh
Дата:
Сообщение: Re: Inserting data of two other tables [Now deleting ...]