Ordering in SELECT statement

From: "kdealba(at)uaaan(dot)mx" <kdealba(at)uaaan(dot)mx>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Ordering in SELECT statement
Date: 2007-06-26 19:41:49
Message-ID: f517195dfb7ed8497616310724e7a0b9@correo.uaaan.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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??? 

Responses

Browse pgsql-general by date

  From Date Subject
Next Message jef peeraer 2007-06-26 19:52:02 upgrade 8.1.4 -> latest, sort order subquery
Previous Message Michael Glaesemann 2007-06-26 19:31:54 Re: Throwing exceptions