Re: [SQL] Bizarre sort order

2008-03-26 Thread Tom Lane
"Conlon, Joseph F SIK" <[EMAIL PROTECTED]> writes: > Does anyone think this is the correct behavior? If you don't think so, you need to change to C locale. regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your su

[SQL] Bizarre sort order

2008-03-26 Thread Conlon, Joseph F SIK
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