Re: Problem wyth Case-sensitive ORDER BY

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Erik Ferencz <ErikFerencz(at)seznam(dot)cz>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Problem wyth Case-sensitive ORDER BY
Date: 2006-10-21 03:35:50
Message-ID: 20061021033550.49455.qmail@web31812.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> 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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2006-10-21 04:22:44 Re: Problem with migration
Previous Message Ketema Harris 2006-10-20 21:07:04 Distinct based on One column