X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id BF2C3D1DA98 for ; Mon, 12 Jan 2004 18:14:27 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 24813-08 for ; Mon, 12 Jan 2004 14:13:57 -0400 (AST) Received: from smtp015.mail.yahoo.com (smtp015.mail.yahoo.com [216.136.173.59]) by svr1.postgresql.org (Postfix) with SMTP id 93CC0D1D8F3 for ; Mon, 12 Jan 2004 14:13:55 -0400 (AST) Received: from unknown (HELO europa.janwieck.net) (janwieck@68.80.245.191 with login) by smtp015.mail.yahoo.com with SMTP; 12 Jan 2004 18:13:55 -0000 Received: from Yahoo.com (ismtp.afilias.com [216.217.55.254]) (authenticated) by europa.janwieck.net (8.11.6/8.11.6) with ESMTP id i0CIETk26838; Mon, 12 Jan 2004 13:14:30 -0500 Message-ID: <4002D588.4030503@Yahoo.com> Date: Mon, 12 Jan 2004 12:12:40 -0500 From: Jan Wieck User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 X-Accept-Language: en-us, en MIME-Version: 1.0 To: aspire420@hotpop.com Cc: Michael Glaesemann , Bruce Momjian , pgsql-admin@postgresql.org, pgsql-hackers@postgresql.org Subject: Re: [HACKERS] IEEE 754 References: <200401050051.i050pDF22348@candle.pha.pa.us> <8C33EA12-3F44-11D8-BA4F-000A95C88220@myrealbox.com> <4002B153.7030705@Yahoo.com> <4002CCFE.7090402@sancharnet.in> <4002CF1D.3030406@Yahoo.com> <4002E0B3.70607@sancharnet.in> In-Reply-To: <4002E0B3.70607@sancharnet.in> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/139 X-Sequence-Number: 12002 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 #