Victor (hvicha(at)mail(dot)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