Postgres Pro
Downloads
Home   >   mailing lists

Order by with spaces and other characters - Mailing list pgsql-general

From mike stanton
Subject Order by with spaces and other characters
Date
Msg-id 000a01c9360b$23b5d8b0$0d6ea8c0@mike
Whole thread Raw
Responses Re: Order by with spaces and other characters
List pgsql-general
Tree view
Hello everyone.
We have a simple problem...that we have keys that include blanks and various other commonly used characters like ",",  ";" and "-". For some reason, the select we have, nothing complicated, ignores these "special" characters and happily sorts by the A-z range. How do we sort by the, say ascii 32-125 range?
This must be a known issue; perhaps we need to configure a parameter.
 
Michael Stanton W.
Depto. Informática
AutoCastillo S.A
Santiago Chile

pgsql-general by date:

Previous
From: "Grzegorz Jaśkiewicz"
Date:
Subject: Re: max time in a table query takes ages
Next
From:
Date:
Subject: JDBC - Call stored function that returns user defined type