On 2010-06-22, Bryan White 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.
> This transcript demonstrates what I am seeing:
>
> bryan=# select * from t order by f;
> f
> ---
> a
>
On 06/23/10 17:45, Jasen Betts wrote:
On 2010-06-22, Bryan White 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'')::b
