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:
http://cap.connx.com/bugreport/pgbug.sql.bz2
Is this a known issue with PostgreSQL or for some reason the desired
behavior?