Re: [HACKERS] IEEE 754

From: Sai Hertz And Control Systems <sank89(at)sancharnet(dot)in>
To: Jan Wieck <JanWieck(at)Yahoo(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 18:00:19
Message-ID: 4002E0B3.70607@sancharnet.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Matthew M.Burke 2004-01-12 18:23:55 Error on system startup
Previous Message Jan Wieck 2004-01-12 17:12:40 Re: [HACKERS] IEEE 754

Browse pgsql-hackers by date

  From Date Subject
Next Message ow 2004-01-12 19:14:02 What's planned for 7.5?
Previous Message Merlin Moncure 2004-01-12 17:56:32 Re: Encoding problems in PostgreSQL with XML data