Thank you, works fine.
Bug reference: 8118 Logged by: whiplash Email address:[email protected] 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 AABIt'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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
