Re: ORDER BY is case insensitive

On 06/23/10 17:45, Jasen Betts wrote:
> On 2010-06-22, Bryan White<nicktook@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.