Skip site navigation (1) Skip section navigation (2)

Re: Bug #952: real type in WHERE

From: hvicha <hvicha(at)mail(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #952: real type in WHERE
Date: 2003-04-23 06:55:49
Message-ID: 20030423105549.63f2755a.hvicha@mail.ru (view raw or flat)
Thread:
Lists: pgsql-bugs
On Tue, 22 Apr 2003 11:25:34 -0400
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> 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.
> 
 Yes, I see: 
victest=# select 1.1::float4 = 1.1::float8;
 ?column? 
----------
 f
(1 row)

;-/

Regards, Vic


In response to

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2003-04-23 11:45:49
Subject: Bug #954: select distinct array
Previous:From: CNDate: 2003-04-23 05:51:50
Subject: UNION Types Mismatch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group