Re: [GENERAL] Order by with spaces and other characters

[Tomasz Myrta]

mike stanton napisal 24.10.2008 21:03:

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.


Sorting behavior depends on database locale. You can override it and 
make Postgres sort output data binary with ORDER BY xxx USING ~~

It's default when database is initialized with C locale.

--
Regards,
Tomasz Myrta

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Order by with spaces and other characters

[mike stanton]

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