Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Strange query behavior where clause produces odd behavior on '>' query
Date
Msg-id 13145.1225413033@sss.pgh.pa.us
Whole thread Raw
In response to Strange query behavior where clause produces odd behavior on '>' query  ("Dann Corbit" <DCorbit@connx.com>)
Responses Re: Strange query behavior where clause produces odd behavior on '>' query
List pgsql-hackers
Tree view 
"Dann Corbit" <DCorbit@connx.com> writes:
> The following query:
> SELECT * FROM Customers_connxstore where customerid > 'specd'
> Returns the row containing Customers_connxstore.customerid == 'SPECD'

What encoding/locale are you using?  And while I'm asking, which PG version?
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Dann Corbit"
Date:
Subject: Strange query behavior where clause produces odd behavior on '>' query
Next
From: "Robert Haas"
Date:
Subject: Re: Sun Studio compiler warnings