Postgres Pro
Downloads
Home   >   mailing lists

Thread: Problem wyth Case-sensitive ORDER BY

Problem wyth Case-sensitive ORDER BY

From
"Erik Ferencz"
Date:
Hi!
It is possible to make ORDER BY not CASE-SENSITIVE ??
 
I need output like this
 
Cardio
cerdio
Cordio
curdio
 
But I always get output like this
 
Cardio
Cordio
cerdio
curdio
 
 
How can I force ORDER BY to ord strings in my way?? I mean, I use charakters like ú.ľ,š,č,ť,ž that have spetial order in my language.
 
Thanks for any help

Re: Problem wyth Case-sensitive ORDER BY

From
Richard Broersma Jr
Date:
> It is possible to make ORDER BY not CASE-SENSITIVE ??
> But I always get output like this
> Cardio
> Cordio
> cerdio
> curdio
> How can I force ORDER BY to ord strings in my way?? I mean, I use charakters like ?,謻,?
> that have spetial order in my language.
> Thanks for any help


may be something like:

select name from foobar order by lower(name);

Regards,

Richard Broersma Jr.