Postgres Pro
Downloads
Home   >   mailing lists

Re: Strange query behavior where clause produces odd behavior on '>' query - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Strange query behavior where clause produces odd behavior on '>' query
Date
Msg-id 14901.1225416856@sss.pgh.pa.us
Whole thread Raw
In response to Re: Strange query behavior where clause produces odd behavior on '>' query  ("Dann Corbit" <DCorbit@connx.com>)
Responses Re: Strange query behavior where clause produces odd behavior on '>' query  ("Dann Corbit" <DCorbit@connx.com>)
List pgsql-hackers
Tree view 
"Dann Corbit" <DCorbit@connx.com> writes:
>> What encoding/locale are you using?  

> Whatever the default encoding/locale is.

"Whatever" is the wrong answer here.  I just finished verifying that the
sort order you're complaining about is the expected ordering in some
locales.  I suggest that you take the trouble to find out.

> Are you unable to reproduce it?

Well, I see this on a Fedora machine:

$ cat foo
specd
SPECD
$ sort foo
SPECD
specd
$ LANG=en_US sort foo
specd
SPECD
$ 
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Dann Corbit"
Date:
Subject: Re: Strange query behavior where clause produces odd behavior on '>' query
Next
From: "Robert Haas"
Date:
Subject: Re: Sun Studio compiler warnings