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

> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Thursday, October 30, 2008 6:34 PM
> To: Dann Corbit
> Cc: [HACKERS]; Sherry Griffin
> Subject: Re: [HACKERS] Strange query behavior where clause produces
odd
> behavior on '>' query
>
> "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.

English (United States) is my locale.

> > 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
> $

The compare works as it should.
The only bug was in my understanding.