Ordering in SELECT statement - Mailing list pgsql-general

From kdealba@uaaan.mx
Subject Ordering in SELECT statement
Date
Msg-id f517195dfb7ed8497616310724e7a0b9@correo.uaaan.mx
Whole thread Raw
Responses Re: Ordering in SELECT statement  (Richard Huxton <dev@archonet.com>)
Re: Ordering in SELECT statement  (Michael Glaesemann <grzm@seespotcode.net>)
List 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 by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: growing disk usage problem: alternative solution?
Next
From: Bill Moran
Date:
Subject: Re: growing disk usage problem: alternative solution?