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

Поиск
Список
Период
Сортировка
От Dann Corbit
Тема Strange query behavior where clause produces odd behavior on '>' query
Дата
Msg-id D425483C2C5C9F49B5B7A41F89441547010011EE@postal.corporate.connx.com
обсуждение исходный текст
Ответы Re: Strange query behavior where clause produces odd behavior on '>' query  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PG_PAGE_LAYOUT_VERSION 5 - time for change
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Strange query behavior where clause produces odd behavior on '>' query