Fw: (Bug) Numeric fault calculation
| От | Kanitchet Vaiassava |
|---|---|
| Тема | Fw: (Bug) Numeric fault calculation |
| Дата | |
| Msg-id | BAY167-DS3285FF28CABDFCF5126BE2D8B40@phx.gbl обсуждение исходный текст |
| Ответы |
Re: Fw: (Bug) Numeric fault calculation
(Michal Kozusznik <kozusznik.michal@ifortuna.cz>)
|
| Список | pgadmin-support |
Dear pg's support and Alexander
Allow me to quote this reference from : http://www.postgresql.org/docs/9.1/static/datatype-numeric.html
"The type numeric can store numbers with a very large number of digits and perform calculations exactly. It is especially recommended for storing monetary amounts and other quantities where exactness is required. However, arithmetic on numeric values is very slow compared to the integer types, or to the floating-point types described in the next section.
We use the following terms below: The scale of a numeric is the count of decimal digits in the fractional part, to the right of the decimal point. The precision of a numeric is the total count of significant digits in the whole number, that is, the number of digits to both sides of the decimal point. So the number 23.5141 has a precision of 6 and a scale of 4. Integers can be considered to have a scale of zero."
Kanitchet Vaiassava
555 Nawamin Rd., Klongkum, Buengkum, Bangkok 10230, Thailand
Mobile +66 89 515 9955; Office +66 2 744 2288; Fax +66 2 379 1166
---------------------------------------------------------------------------------------------------------------
(Bug) Numeric fault calculationMy company has using postgresql as database for ERP application which in-house developed.For store financial and accounting data, we chose "numeric" type for accurate calculation (and with recommend by postgres's documentation) and we faced the problem by using "double precision" before.However, we found that by using numeric had the problem too.In our formula for calculate interest for customer's overdue payment that using numeric,we found that it had fault calculate. So, it effected our interest amount.In the attached file you can see that the result from postgresql and by using long division method is difference.postgresql : 714.35599999999xxxxlong division method: 714.356and if we multiply this result with interest rate and others factor and round up later. the amount is miscalculate.Thank you and sorry for bad english gramma.Best Regards,
Kanitchet VaiassavaThaiAce Group
555 Nawamin Rd., Klongkum, Buengkum, Bangkok 10230, Thailand
Mobile +66 89 515 9955; Office +66 2 744 2288; Fax +66 2 379 1166
---------------------------------------------------------------------------------------------------------------
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
--
Regards,
Alexander Yerenkow
В списке pgadmin-support по дате отправления: