Re: ORDER BY Problem

From: Tod McQuillin <devin(at)spamcop(dot)net>
To: Severin Olloz <S(dot)Olloz(at)soid(dot)ch>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: ORDER BY Problem
Date: 2001-06-06 02:45:38
Message-ID: Pine.GSO.4.33.0106052144380.7719-100000@sysadmin
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Eric G. Miller 2001-06-06 02:57:50 Re: Sequences in transaction context
Previous Message Eric G. Miller 2001-06-06 02:33:08 Re: ORDER BY Problem