Re: ORDER BY options (how to order data as AAA, aaa, BBB, bbb, ... ZZZ, zzz) - Mailing list 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@postgresql.org)