"Nikhil Sontakke" <nikhil.sonta...@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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
