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 77632D1B461; Mon, 12 Jan 2004 16:33:23 +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 98509-04; Mon, 12 Jan 2004 12:32:52 -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 7E3CED1CA0E; Mon, 12 Jan 2004 12:32:51 -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 <0HRD00G01XMB49@ndl1mr1-a-fixed.sancharnet.in>; Mon, 12 Jan 2004 22:00:34 +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 <0HRD00FWCXTX9J@ndl1mr1-a-fixed.sancharnet.in>; Mon, 12 Jan 2004 22:00:34 +0530 (IST) Date: Mon, 12 Jan 2004 22:06:14 +0530 From: Sai Hertz And Control Systems Subject: Re: [HACKERS] IEEE 754 In-reply-to: <4002B153.7030705@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: <4002CCFE.7090402@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> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/90 X-Sequence-Number: 11953 Dear Jan Wieck , >>> Floating point math itself is not precise, but rather an approximation, >>> usually of 8 or 14 digits. You can't approximate money. This isn't a >>> PostgreSQL issue but rather a general programming issue. >> >> >> Thanks, Bruce. I assume the arbitrary precision arithmetic Jan >> mentioned which is used for the NUMERIC type takes care of this. > > > That was the whole intention. Although Bruce is wrong, since most of > the time money is approximated. It is only in "bookkeeping" where this > is not allowed. 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. Regards, Vishal Kashyap