Re: BUG #8118: Wrong sorting text

>> Bug reference:      8118
>> Logged by:          whiplash
>> Email address:      whiplash@bss.org.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