Re: [HACKERS] IEEE 754

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: aspire420(at)hotpop(dot)com
Cc: Michael Glaesemann <grzm(at)myrealbox(dot)com>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] IEEE 754
Date: 2004-01-12 17:12:40
Message-ID: 4002D588.4030503@Yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

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(at)Yahoo(dot)com #

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Sai Hertz And Control Systems 2004-01-12 18:00:19 Re: [HACKERS] IEEE 754
Previous Message Jan Wieck 2004-01-12 16:45:17 Re: [HACKERS] IEEE 754

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2004-01-12 17:48:43 Re: psql \d option list overloaded
Previous Message Jan Wieck 2004-01-12 16:45:17 Re: [HACKERS] IEEE 754