megafon=# \d aaa
Table "public.aaa"
Column | Type | Modifiers
--------+------+-----------
num | real |
Yes, really, on smaller quantity of digits of errors is not present.
What type of the data is better for using? Numbers up to 100000 and accuracy of 2 fractional signs.
30.05.10, 21:43, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> "Sergey" <viras(at)yandex(dot)ru> writes:8849.15+6464.57=15313.72But sum()=15313.7You did not show what datatype you're summing, but if the column isfloat4 this result wouldn't be surprising. float4 is only goodto about six decimal digits. regards, tom lane