Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Bizarre sort order



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.



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group