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" <t...@sss.pgh.pa.us>: > "Sergey" <vi...@yandex.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
