Re: Bug #952: real type in WHERE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: hvicha(at)mail(dot)ru, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #952: real type in WHERE
Date: 2003-04-22 15:25:34
Message-ID: 3075.1051025134@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Joe Slag 2003-04-22 18:02:23 parallel pg installation and functions gotcha
Previous Message pgsql-bugs 2003-04-22 10:37:27 Bug #952: real type in WHERE