Order by with spaces and other characters

From: "mike stanton" <mstanton(at)acsa(dot)cl>
To: <pgsql-general(at)postgresql(dot)org>
Cc: <mstanton(at)acsa(dot)cl>
Subject: Order by with spaces and other characters
Date: 2008-10-24 19:03:02
Message-ID: 000a01c9360b$23b5d8b0$0d6ea8c0@mike
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2008-10-24 19:08:38 Re: max time in a table query takes ages
Previous Message Jack Orenstein 2008-10-24 18:21:50 Re: Postgres optimizer choosing wrong index