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

From Jan Wieck
Subject Re: [HACKERS] IEEE 754
Date
Msg-id 4002D588.4030503@Yahoo.com
Whole thread Raw
In response to Re: [HACKERS] IEEE 754  (Sai Hertz And Control Systems <sank89@sancharnet.in>)
List pgsql-admin
Sai Hertz And Control Systems wrote:

> 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

If that is what Indian accounting rules require, that is what you do.


Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


pgsql-admin by date:

Previous
From: Jan Wieck
Date:
Subject: Re: [HACKERS] IEEE 754
Next
From: Matthew M.Burke
Date:
Subject: Error on system startup