Bizarre sort order - Mailing list pgsql-sql

From Conlon, Joseph F SIK
Subject Bizarre sort order
Date
Msg-id E0076A8FFB8D8F45AA1423A4D4F383BC01594392@UUSNWEG4.na.utcmail.com
Whole thread Raw
Responses Re: Bizarre sort order
List pgsql-sql
Does anyone think this is the correct behavior?

adaps_db=# select * from upc_usage order by 1 ; usage
----------53EABCCYPHER_GENERALH66HAWK_JOERSRAS61S65S70S76S92XWING
(14 rows)

It appears to be ignoring the underscore!

Database has LATIN1 encoding and was recently migrated from 8.0 to 8.3.


pgsql-sql by date:

Previous
From: "Matthew T. O'Connor"
Date:
Subject: Finding all References to a Primary Key
Next
From: Tom Lane
Date:
Subject: Re: Bizarre sort order