The following query:
SELECT * FROM Customers_connxstore where customerid > 'specd'
Returns the row containing Customers_connxstore.customerid == 'SPECD'
I would expect to get that row if the query was:
SELECT * FROM Customers_connxstore where customerid >= 'specd'
The other operators (<, <=, >, =, !=) all work as expected.
Sample file to reproduce the problem:
Is this a known issue with PostgreSQL or for some reason the desired
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2008-10-31 00:30:33|
|Subject: Re: Strange query behavior where clause produces odd behavior on '>' query |
|Previous:||From: Tom Lane||Date: 2008-10-30 23:54:43|
|Subject: Re: PG_PAGE_LAYOUT_VERSION 5 - time for change |