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

2013-04-29 Thread 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

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

2013-04-28 Thread Daniele Varrazzo 
 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