Re: Money casting too liberal?
От | John R Pierce |
---|---|
Тема | Re: Money casting too liberal? |
Дата | |
Msg-id | 515B208B.2040606@hogranch.com обсуждение исходный текст |
Ответ на | Re: Money casting too liberal? (Gavin Flower <GavinFlower@archidevsys.co.nz>) |
Ответы |
Re: Money casting too liberal?
|
Список | pgsql-general |
On 4/2/2013 12:50 AM, Gavin Flower wrote:
In the bad old days when I was a COBOL programmer we always stored money in the COBOL equivalent of an integer (numeric without a fractional part) to avoid round off, but we displayed with a decimal point to digits to the left. So storing as an integer (actually bigint would be required) is a good idea, with parameters to say how many effective digits in the fractional part, and how many fractional digits to display etc. - as you said.
COBOL Numeric was BCD. same as NUMERIC in SQL (yes, I know postgresql internally uses a base 10000 notation for this, storing it as an array of short ints, but effectively its equivalent to BCD).
-- john r pierce 37N 122W somewhere on the middle of the left coast
В списке pgsql-general по дате отправления: