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 5:31 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:
> > The following query:
> > SELECT * FROM Customers_connxstore where customerid > 'specd'
> > Returns the row containing Customers_connxstore.customerid ==
'SPECD'
>
> What encoding/locale are you using?

Whatever the default encoding/locale is.
I did not define any custom encoding, locale, or collating sequence.

> And while I'm asking, which PG
> version?

All versions from PostgreSQL 7.1.3 to "PostgreSQL 8.3.3, compiled by
Visual C++ build 1400" seem to display this behavior.
Are you unable to reproduce it?