From: | Radek Kanovsky <radekk(at)uh(dot)cz> |
---|---|
To: | pgsql-sql(at)postgreSQL(dot)org |
Subject: | 11128.1 != 11128.1 |
Date: | 1999-09-25 15:15:11 |
Message-ID: | Pine.LNX.3.96.990925165406.18476r-100000@rk.uh.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi,
I have one table defined as follows:
CREATE TABLE bank (
....
incr FLOAT NOT NULL DEFAULT 0.0 ,
....) ;
When I make query
SELECT * FROM bank WHERE incr = 11128.1;
it returns no result although at least one row satisfy this condition.
I can get result only with modified query
SELECT * FROM bank WHERE round(incr,1) = round(11128.1,1);
Is there some error in libc,OS or postgres? I have tried
to dump-destroy-create-restore whole database and
it looked good but after few hours I got into trouble again.
I run 6.5.1 version, compiled with gcc 2.95.1 (libc-2.1.2)
on Debian Linux 2.2.11.
Radek Kanovsky, rk(at)uh(dot)cz
From | Date | Subject | |
---|---|---|---|
Next Message | Radek Kanovsky | 1999-09-25 17:51:01 | create function(date,date,date,...) |
Previous Message | Engard Ferenc | 1999-09-25 13:35:45 | Re: [SQL] comparing 2 tables. . . |