Postgres Pro
Downloads
Home   >   mailing lists

Re: Bug #952: real type in WHERE - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug #952: real type in WHERE
Date
Msg-id 3075.1051025134@sss.pgh.pa.us
Whole thread Raw
In response to Bug #952: real type in WHERE  (pgsql-bugs@postgresql.org)
Responses Re: Bug #952: real type in WHERE
List pgsql-bugs
Tree view 
pgsql-bugs@postgresql.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.

            regards, tom lane

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #952: real type in WHERE
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #953: pg_dump dies on tables with no columns