On 03/04/13 07:16, John R Pierce wrote:
> 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
It was many years ago! :-)