Postgres Pro
Downloads
Home   >   mailing lists

Re: ORDER BY options (how to order data as AAA, aaa, - Mailing list pgsql-general

From Ragnar Hafstað
Subject Re: ORDER BY options (how to order data as AAA, aaa,
Date
Msg-id 1115720640.24340.13.camel@localhost.localdomain
Whole thread Raw
In response to ORDER BY options (how to order data as AAA, aaa, BBB, bbb, ... ZZZ, zzz)  (Julian Legeny <julo@opensubsystems.org>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Sim Zacks"
Date:
Subject: Re: ORDER BY options (how to order data as AAA, aaa, BBB, bbb, ... ZZZ, zzz)
Next
From: Julian Legeny
Date:
Subject: Re: ORDER BY options (how to order data as AAA, aaa, BBB, bbb, ... ZZZ, zzz)