Bizarre sort order

From: "Conlon, Joseph F SIK" <JConlon(at)SIKORSKY(dot)COM>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Bizarre sort order
Date: 2008-03-26 17:55:44
Message-ID: E0076A8FFB8D8F45AA1423A4D4F383BC01594392@UUSNWEG4.na.utcmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Does anyone think this is the correct behavior?

adaps_db=# select * from upc_usage order by 1 ;
usage
----------
53E
ABC
CYPHER
_GENERAL
H66
HAWK
_JOE
RSRA
S61
S65
S70
S76
S92
XWING
(14 rows)

It appears to be ignoring the underscore!

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2008-03-26 18:14:35 Re: FW: Re: Part 1 of several - Converting a varchar to an interval
Previous Message Adrian Klaver 2008-03-26 17:30:29 Re: FW: Re: Part 1 of several - Converting a varchar to an interval