dear sir, when i run a query with order by customer_name i am getting the following result(ex.).
AA A B AC
i want it to be
A B AA AB
Sorting is down to your locale (the LC_xxx configuration settings). This is set when you initdb your database. It looks to me like you want "C" sorting, so dump your database, re-initdb with --locale=C and restore the dump.
There's a whole chapter on localisation in the manuals. Make sure you are clear on the difference between encoding and locale.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
