"Dann Corbit" <DCorbit(at)connx(dot)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