Re: ORDER BY options (how to order data as AAA, aaa,

From: Ragnar Hafstað <gnari(at)simnet(dot)is>
To: Juleni <julo(at)opensubsystems(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ORDER BY options (how to order data as AAA, aaa,
Date: 2005-05-10 10:24:00
Message-ID: 1115720640.24340.13.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2005-05-10 at 11:41 +0200, Julian Legeny wrote:

> ...
> But I would like to sort all data as following:
>
> NAME
> -----------
> AAA
> aaa
> BBB
> bbb
> CCC
> ccc

> How can I write sql command (or set up ORDER BY options) for selecting that?

how about ORDER BY lower(NAME),NAME ?

gnari

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Julian Legeny 2005-05-10 10:28:19 Re: ORDER BY options (how to order data as AAA, aaa, BBB, bbb, ... ZZZ, zzz)
Previous Message Russell Smith 2005-05-10 10:14:38 Re: ORDER BY options (how to order data as AAA, aaa, BBB, bbb, ... ZZZ, zzz)