| 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: | Whole Thread | Raw Message | 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 |