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

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 (view raw or flat)
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

pgsql-novice by date

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

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