sorting problem - Mailing list pgsql-bugs

From CK Leung
Subject sorting problem
Date
Msg-id 49F836E0.503@wecity.com
Whole thread Raw
Responses Re: sorting problem  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-bugs
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 !!!!

pgsql-bugs by date:

Previous
From: "Pablo M. Ronchi"
Date:
Subject: BUG #4786: Solution for: PostgreSQL server did not start (NET HELPMSG 3534)
Next
From: Craig Ringer
Date:
Subject: Re: Help me to solve this problem!