On Tue, 22 Apr 2003 11:25:34 -0400
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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 is
> exactly equal to 1.1::float8.
>
Yes, I see:
victest=# select 1.1::float4 = 1.1::float8;
?column?
----------
f
(1 row)
;-/
Regards, Vic