Problem wyth Case-sensitive ORDER BY

From: "Erik Ferencz" <ErikFerencz(at)seznam(dot)cz>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Problem wyth Case-sensitive ORDER BY
Date: 2006-10-11 12:26:55
Message-ID: 000001c6f2d7$6eb0f8a0$fc01a8c0@a040725b
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Brandon Aiken 2006-10-11 12:56:09 Re: [ADMIN] Copying data from table to table (cloned tables)
Previous Message Fourat Zouari 2006-10-11 11:30:22 Re: Copying data from table to table (cloned tables)