pgsql-bugs(at)postgresql(dot)org writes:> victest=# SELECT * FROM t WHERE r=1.1;
The 1.1 is taken as a float8 constant. There is no float4 value that isexactly equal to 1.1::float8.
regards, tom lane