Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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);


Richard Broersma Jr.

In response to

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group