Envelope-to: pgsql-sql@postgresql.org
Message-ID: <4C22E3F3.6040506@bankir.ru>
Date: Thu, 24 Jun 2010 08:49:55 +0400
From: silly sad <sad@bankir.ru>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.5)
	Gecko/20100111 Thunderbird/3.0
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: ORDER BY is case insensitive
References: <AANLkTimupyTgU-h-LKkV9VprzFopMMBKqsoO2RVpAzgL@mail.gmail.com>
	<hvt35i$p4j$1@reversiblemaps.ath.cx>
In-Reply-To: <hvt35i$p4j$1@reversiblemaps.ath.cx>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 06/23/10 17:45, Jasen Betts wrote:
> On 2010-06-22, Bryan White<nicktook@gmail.com>  wrote:
>> I was suprised to find out that ORDER BY is case insensitive.  Is
>> there a way to do a case sensitive ORDER BY clause?
>
> use bytea instead of a text type.
>
>   try this:
>
>   select * from t order by replace(f,e'\\', e'\\\\')::bytea
>
> you may want to index on  replace(f,e'\\', e'\\\\')::bytea

certainly wrong way.
keyword is "multibyte chars".

as he asked about case sensitivity, i presume he still want to preserve 
alphabet order -- u propose to cancel alphabet order at all.