"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes:
Description: Order by doesn't sort correctly.
It almost certainly is the correct sort order according to the locale you're using. Use pg_controldata to check the database locale. You'll probably want to re-initdb in C locale. Most non-C locales have weird rules that try to approximate dictionary sort order.
regards, tom lane
Dear Tom,
Thanks for your email. I did check pg_controldata and found: LC_COLLATE: en_GB LC_CTYPE: en_GB
The bug isn't the particular ascii-betical (or other) order. But what I am getting as a supposedly ordered list includes:
Cymbal #1 Cymbal - 18 inch Cymbal #2
This ordering is perverse! No matter what the priority is of the different characters, I cannot understand how the above can arise.
Whether '#' comes before or after '-', '#1' and '#2' should be adjacent.
Richard
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
