Thank you, works fine.
>>> 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
>