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

From Dann Corbit
Subject Re: Strange query behavior where clause produces odd behavior on '>' query
Date
Msg-id D425483C2C5C9F49B5B7A41F89441547010011F1@postal.corporate.connx.com
Whole thread Raw
In response to Re: Strange query behavior where clause produces odd behavior on '>' query  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.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@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.

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.



pgsql-hackers by date:

Previous
From: "Robert Haas"
Date:
Subject: Re: Sun Studio compiler warnings
Next
From: "Robert Haas"
Date:
Subject: Re: BufferAccessStrategy for bulk insert