>> Bug reference: 8118 >> Logged by: whiplash >> Email address: whipl...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs