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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dann Corbit" <DCorbit(at)connx(dot)com>
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 00:30:33
Message-ID: 13145.1225413033@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"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? And while I'm asking, which PG version?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2008-10-31 01:04:27 Re: Sun Studio compiler warnings
Previous Message Dann Corbit 2008-10-31 00:17:23 Strange query behavior where clause produces odd behavior on '>' query