Postgres Pro
Downloads
Home   >   mailing lists

Re: ORDER BY Problem - Mailing list pgsql-general

From Eric G. Miller
Subject Re: ORDER BY Problem
Date
Msg-id 20010605193308.C23813@calico.local
Whole thread Raw
In response to ORDER BY Problem  (Severin Olloz <S.Olloz@soid.ch>)
List pgsql-general
Tree view 
On Wed, Jun 06, 2001 at 03:17:36AM +0200, Severin Olloz wrote:
> Hello...
>
> Why does Postgresql order the uppercase letters first?

Because all uppercase letters come before the lowercase letters. Maybe
"ORDER BY lower(<column>)" will work?  This should also be locale
dependent ...

--
Eric G. Miller <egm2@jps.net>

pgsql-general by date:

Previous
From: "Erik Pearson"
Date:
Subject: Sequences in transaction context
Next
From: Tod McQuillin
Date:
Subject: Re: ORDER BY Problem