Re: float8 strtod weirdness - Mailing list pgsql-hackers

"Nikhil Sontakke" <nikhil.sontakke@enterprisedb.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