Re: BUG #8118: Wrong sorting text

>> Bug reference: 8118
>> Logged by: whiplash
>> Email address: whiplash(at)bss(dot)org(dot)ua
>> PostgreSQL version: 9.2.2
>> Operating system: Linux (Fedora 11, Fedora 16 and Ubuntu 12.04)
>> Description:
>>
>> I execute query (1):
>>
>> SELECT t.name
>> FROM
>> (
>> SELECT 'AAA AAA' AS name
>> UNION ALL
>> SELECT 'AAA_AAA'
>> UNION ALL
>> SELECT 'BBB_AAA'
>> UNION ALL
>> SELECT 'BBB AAB'
>> ) t
>> ORDER BY t.name
>>
>> and I getting a result:
>>
>> AAA AAA
>> AAA_AAA
>> BBB_AAA
>> BBB AAB

It's a matter of collate. If you want ascii ordering specify collate "C".

...
ORDER BY t.name collate "C";
name
---------
AAA AAA
AAA_AAA
BBB AAB
BBB_AAA
(4 rows)

-- Daniele