SELECT * FROM MY_TABLE ORDER BY LOWER(NAME);
Thanks
Dinesh Pandey
-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Julian Legeny
Sent: Tuesday, May 10, 2005 3:12 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] ORDER BY options (how to order data as AAA, aaa, BBB, bbb, ... ZZZ, zzz)
Hello,
I have following problem:
I have table MY_TABLE with following records:
NAME
-----------
ccc
CCC
AAA
aaa
bbb
BBB
When I use default select that sort all data by NAME:
SELECT * FROM MY_TABLE ORDER BY NAME;
result is following:
NAME
-----------
AAA
BBB
CCC
aaa
bbb
ccc
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?
Thank you in advance for answer,
best regards,
Julian Legeny
mailto:julo@opensubsystems.org
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster