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 15481D1D236; Mon, 12 Jan 2004 17:55:19 +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 14454-10; Mon, 12 Jan 2004 13:54:48 -0400 (AST) Received: from ndl1mr1-a-fixed.sancharnet.in (ndl1mr1-a-fixed.sancharnet.in [61.0.0.45]) by svr1.postgresql.org (Postfix) with ESMTP id 1643DD1D54C; Mon, 12 Jan 2004 13:54:47 -0400 (AST) Received: from conversion-daemon.ndl1mr1-a-fixed.sancharnet.in by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 1.17 (built Jun 23 2003)) id <0HRE007011EBPQ@ndl1mr1-a-fixed.sancharnet.in>; Mon, 12 Jan 2004 23:24:46 +0530 (IST) Received: from sancharnet.in ([61.0.95.108]) by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 1.17 (built Jun 23 2003)) with ESMTPA id <0HRE00FLR1Q59J@ndl1mr1-a-fixed.sancharnet.in>; Mon, 12 Jan 2004 23:24:46 +0530 (IST) Date: Mon, 12 Jan 2004 23:30:19 +0530 From: Sai Hertz And Control Systems Subject: Re: [HACKERS] IEEE 754 In-reply-to: <4002CF1D.3030406@Yahoo.com> To: Jan Wieck Cc: Michael Glaesemann , Bruce Momjian , pgsql-admin@postgresql.org, pgsql-hackers@postgresql.org Reply-To: aspire420@hotpop.com Message-id: <4002E0B3.70607@sancharnet.in> Organization: Sai Hertz And Control Systems MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 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> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/91 X-Sequence-Number: 11954 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