Re: [BUGS] BUG #8118: Wrong sorting text

[whiplash]

Thank you, works fine.

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