Strange query behavior where clause produces odd behavior on '>' query - Mailing list pgsql-hackers

From Dann Corbit
Subject Strange query behavior where clause produces odd behavior on '>' query
Date
Msg-id D425483C2C5C9F49B5B7A41F89441547010011EE@postal.corporate.connx.com
Whole thread Raw
Responses Re: Strange query behavior where clause produces odd behavior on '>' query
List pgsql-hackers
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?



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: PG_PAGE_LAYOUT_VERSION 5 - time for change
Next
From: Tom Lane
Date:
Subject: Re: Strange query behavior where clause produces odd behavior on '>' query