pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedBizarre sort order
2+ messages / 2 participants
[nested] [flat]
* Bizarre sort order
@ 2008-03-26 17:55 Conlon, Joseph F SIK <JConlon@SIKORSKY.COM>
2008-03-26 19:26 ` Re: Bizarre sort order Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Conlon, Joseph F SIK @ 2008-03-26 17:55 UTC (permalink / raw)
To: 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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Bizarre sort order
2008-03-26 17:55 Bizarre sort order Conlon, Joseph F SIK <JConlon@SIKORSKY.COM>
@ 2008-03-26 19:26 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2008-03-26 19:26 UTC (permalink / raw)
To: Conlon, Joseph F SIK <JConlon@SIKORSKY.COM>; +Cc: pgsql-sql
"Conlon, Joseph F SIK" <JConlon@SIKORSKY.COM> 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-03-26 19:26 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-03-26 17:55 Bizarre sort order Conlon, Joseph F SIK <JConlon@SIKORSKY.COM>
2008-03-26 19:26 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox