Re: Strange query behavior where clause produces odd behavior on '>' query

"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