"Nikhil Sontakke" <nikhil(dot)sontakke(at)enterprisedb(dot)com> writes:
> Consider the following with latest CVS sources:
> postgres=# create table temp(val float4);
> CREATE TABLE
> postgres=# insert into temp values (415.1);
> INSERT 0 1
> postgres=# select * from temp where val = 415.1;
Anybody who works with float arithmetic can tell you that exact equality
tests are usually a bad idea.
regards, tom lane