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

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)