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
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 |
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 |