Re: [HACKERS] IEEE 754 - Mailing list pgsql-admin

From Sai Hertz And Control Systems
Subject Re: [HACKERS] IEEE 754
Date
Msg-id 4002E0B3.70607@sancharnet.in
Whole thread Raw
In response to Re: [HACKERS] IEEE 754  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [HACKERS] IEEE 754  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-admin
Dear Jan Wieck  ,

>>
>> Yes I agree with you Jan , most of the time we round the amount  and
>> this is done by  truncating greater than 3 decimal digits and
>> rounding the 3 digit to 2  in other words :
>> select trunc(1000.236897,3);
>> then
>> selecr round(1000.236,2);
>> This takes care of the rounding factor in money as per Indian
>> standards ok, how will you verify it simple just use log and you will
>> get the correct output.
>
>
> People are often under the impression that effective APR's and all
> that stuff fall into the same category as your bank or credit card
> account balance. But that is not true.

What are you suggesting thattruncing and  rounding is not good  in
financial terms

Regards,
Vishal Kashyap


pgsql-admin by date:

Previous
From: Sai Hertz And Control Systems
Date:
Subject: Re: [HACKERS] IEEE 754
Next
From: ListSrv
Date:
Subject: Tablerights for User in Group