Postgres Pro
Downloads
Home   >   mailing lists

Re: ORDER BY Problem - Mailing list pgsql-general

From Tod McQuillin
Subject Re: ORDER BY Problem
Date
Msg-id Pine.GSO.4.33.0106052144380.7719-100000@sysadmin
Whole thread Raw
In response to ORDER BY Problem  (Severin Olloz <S.Olloz@soid.ch>)
List pgsql-general
Tree view 
On Wed, 6 Jun 2001, Severin Olloz wrote:

> Why does Postgresql order the uppercase letters first?

Because that's how ASCII does it.

If you want non case-sensitive ordering, ORDER BY upper(column)
--
Tod McQuillin

pgsql-general by date:

Previous
From: "Eric G. Miller"
Date:
Subject: Re: ORDER BY Problem
Next
From: Doug McNaught
Date:
Subject: Re: Sequences in transaction context