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