Re: ORDER BY options (how to order data as AAA, aaa, BBB, bbb, ... ZZZ, zzz)

From: Julian Legeny <julo(at)opensubsystems(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: ORDER BY options (how to order data as AAA, aaa, BBB, bbb, ... ZZZ, zzz)
Date: 2005-05-10 10:28:19
Message-ID: 1299998290.20050510122819@opensubsystems.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

that's what I was looking for.

Thanks to all for advices,
with best regards,

Julian Legeny

Tuesday, May 10, 2005, 12:14:38 PM, you wrote:

RS> SELECT * FROM MY_TABLE ORDER BY lower(NAME), NAME

RS> The second NAME is to ensure that AAA comes before aaa, otherwise the order is undetermined.

RS> ---------------------------(end of broadcast)---------------------------
RS> TIP 2: you can get off all lists at once with the unregister command
RS> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message joffer 2005-05-10 10:43:29 unsuscribe
Previous Message Ragnar Hafstað 2005-05-10 10:24:00 Re: ORDER BY options (how to order data as AAA, aaa,