Ordering in SELECT statement

Поиск
Список
Период
Сортировка
От kdealba@uaaan.mx
Тема Ordering in SELECT statement
Дата
Msg-id f517195dfb7ed8497616310724e7a0b9@correo.uaaan.mx
обсуждение исходный текст
Ответы Re: Ordering in SELECT statement  (Richard Huxton <dev@archonet.com>)
Re: Ordering in SELECT statement  (Michael Glaesemann <grzm@seespotcode.net>)
Список pgsql-general

Hello,

I use the following command "SELECT * FROM employees ORDER BY name" (a very simple sql statement) the main thing here is that I get a list ordered without taking into accound the spaces. For example, I get the following listing:
ABAB
AB  CD
ABD  E
AB  EF

and what I need is the following ("old fashion", that is, the "SPACE" is another character whose ASCII value is before any other LATIN letter's!!)
AB  CD
AB  EF
ABAB
ABD  E

Does any one know how to order get an old fashioned SORT??? 

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: growing disk usage problem: alternative solution?
Следующее
От: Bill Moran
Дата:
Сообщение: Re: growing disk usage problem: alternative solution?