I found some problem about the sorting when i switch to pg version 8.3.4
Table name : tt,
record list :
item_code
----------------------
VAAAA
VBBBB
VCCC
(V)BBBB
V.BBBB
V.AAAAB
V.AAAA
.VAAAA
VA.AAA
(VBBBB
V)BBBB
(V)B.BBB
(VB)BBB
(13 rows)
the result : select * from tt order by item_code;
item_code
----------------------
VAAAA
.VAAAA
V.AAAA
VA.AAA
V.AAAAB
VBBBB
(VBBBB
(V)BBBB
(V)B.BBB
(VB)BBB
V.BBBB
V)BBBB
VCCC
(13 rows)
the sort sequence like ignore the character '.' , '(', ')'. Is it a bug ?
It is no problem in old version !!!!
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
