11128.1 != 11128.1

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

In response to

Browse pgsql-sql by date

  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. . .