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 54EAED1B4AD for ; Mon, 29 Dec 2003 20:16: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 74095-02 for ; Mon, 29 Dec 2003 16:15:38 -0400 (AST) Received: from smtp102.mail.sc5.yahoo.com (smtp102.mail.sc5.yahoo.com [216.136.174.140]) by svr1.postgresql.org (Postfix) with SMTP id 28557D1B49C for ; Mon, 29 Dec 2003 16:14:45 -0400 (AST) Received: from unknown (HELO europa.janwieck.net) (janwieck@68.80.245.191 with login) by smtp102.mail.sc5.yahoo.com with SMTP; 29 Dec 2003 20:14:46 -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 hBTKEhY23661; Mon, 29 Dec 2003 15:14:44 -0500 Message-ID: <3FF07CE9.5070707@Yahoo.com> Date: Mon, 29 Dec 2003 14:13:45 -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: pgsql-admin@postgresql.org, pgsql-hackers@postgresql.org Subject: Re: [HACKERS] IEEE 754 References: <3FF06449.7080208@sancharnet.in> In-Reply-To: <3FF06449.7080208@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/16 X-Sequence-Number: 11879 Sai Hertz And Control Systems wrote: > Dear all , > > I would like to share my concerns about the IEEE 754 specification and > floating point handling by PostgreSQL . > > Also I would like to learn how professional users of PostgreSQL work > with rounding of monetary terms . For all monetary values the PostgreSQL datatype NUMERIC should be used. It is a builtin datatype using arbitrary precision math. Jan > > If you would like to know whats IEEE 754 read this > http://docs.sun.com/source/806-3568/ncg_goldberg.html > > > Regards, > Vishal Kashyap. > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #