Bug #952: real type in WHERE

Victor (hvicha@mail.ru) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
real type in WHERE

Long Description
Strange result for real type in WHERE, see example.

Sample Code
victest=# CREATE TABLE t (r real);
CREATE
victest=# INSERT INTO t (r) VALUES (1.0);
INSERT 1309087 1
victest=# INSERT INTO t (r) VALUES (1.1);
INSERT 1309145 1
victest=# INSERT INTO t (r) VALUES (1.2);
INSERT 1309146 1
victest=# SELECT * FROM t WHERE r=1.1;
 r
---
(0 rows)
victest=# SELECT * FROM t WHERE r='1.1';
  r
-----
 1.1
(1 row)


No file was uploaded with this report