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

"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