Skip site navigation (1) Skip section navigation (2)

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

From: "Dann Corbit" <DCorbit(at)connx(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "[HACKERS]" <pgsql-hackers(at)postgresql(dot)org>,"Sherry Griffin" <sgriffin(at)connx(dot)com>
Subject: Re: Strange query behavior where clause produces odd behavior on '>' query
Date: 2008-10-31 01:54:56
Message-ID: D425483C2C5C9F49B5B7A41F89441547010011F1@postal.corporate.connx.com (view raw or flat)
Thread:
Lists: pgsql-hackers
> -----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.


In response to

pgsql-hackers by date

Next:From: Robert HaasDate: 2008-10-31 02:46:49
Subject: Re: BufferAccessStrategy for bulk insert
Previous:From: Robert HaasDate: 2008-10-31 01:37:50
Subject: Re: Sun Studio compiler warnings

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group