On 06/23/10 17:45, Jasen Betts wrote:
On 2010-06-22, Bryan White<nickt...@gmail.com> wrote:
I was suprised to find out that ORDER BY is case insensitive. Is
there a way to do a case sensitive ORDER BY clause?
use bytea instead of a text type.
try this:
select * from t order by replace(f,e'\\', e'\\\\')::bytea
you may want to index on replace(f,e'\\', e'\\\\')::bytea
certainly wrong way.
keyword is "multibyte chars".
as he asked about case sensitivity, i presume he still want to preserve
alphabet order -- u propose to cancel alphabet order at all.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql