Re: Problem wyth Case-sensitive ORDER BY - Mailing list pgsql-novice

From Richard Broersma Jr
Subject Re: Problem wyth Case-sensitive ORDER BY
Date
Msg-id 20061021033550.49455.qmail@web31812.mail.mud.yahoo.com
Whole thread Raw
In response to Problem wyth Case-sensitive ORDER BY  ("Erik Ferencz" <ErikFerencz@seznam.cz>)
List 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.

pgsql-novice by date:

Previous
From: Ketema Harris
Date:
Subject: Distinct based on One column
Next
From: Tom Lane
Date:
Subject: Re: Problem with migration