Postgresql problem with update double precision

From: Condor <condor(at)stz-bg(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Postgresql problem with update double precision
Date: 2011-08-05 10:48:53
Message-ID: 5c3ada0c2a073d94f06843c15372dc9c@stz-bg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello ppl,
for few years I have problem when update double precision field. I have
table and few double precision columns, here is example:

sumall double precision,
sumin double precision,

My php script do:

$get = 2.40

and sql code is:

UPDATE table1 SET sumall = sumall + $get WHERE id = 1 AND rd =
CURRENT_DATE;

When I browse the table some times i see incorrect values like:

955.599999999998

it's should be 955.60 after these updates ... some days is fine, some
days the value is incorrect.

I have this problem from version 7 of postgresql, Im now use 9.0.3

Anyone know what can be the problem and why some times records is fine,
some times isnt ?

--
Regards,
Condor

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim Uckun 2011-08-05 10:51:24 Select count with offset returns nothing.
Previous Message Tomas Vondra 2011-08-05 10:26:49 Re: postgres table have a large number of relpages and occupied a big memory size