Simon Moses wrote:
> 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
