| 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: | Whole Thread | Raw Message | 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
| 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 |