Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id D7C989FB7B2 for ; Tue, 17 Apr 2007 16:18:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 00223-01 for ; Tue, 17 Apr 2007 16:18:18 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web31804.mail.mud.yahoo.com (web31804.mail.mud.yahoo.com [68.142.207.67]) by postgresql.org (Postfix) with SMTP id D73159FB435 for ; Tue, 17 Apr 2007 16:18:17 -0300 (ADT) Received: (qmail 59330 invoked by uid 60001); 17 Apr 2007 19:18:16 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=yfKz2Of4c5DBWXmnynEeSVU5Na0Hv6kziivuqtUD1W4uZvONlZvECnm5FYEFuCfQjP2U46gMOsAAoZrOYulKCewZsScRExbvl6I40vrMFJnIzWHV2r6g6sasIyJgZoTDJa9fawOcD1Ia6LBDQfqZs3D3N2eanHGieKJHNZfmxR8=; X-YMail-OSG: fZxCCtQVM1nCVqwc.E0rwl7qkM5DTqDfMJv.yKjlc_7WU0J4ditmoDHmbCOCI3YqXyGOBgZIBZL4M78AQaA5Ndl5EUoVMwBFisiYKls0XKoEZ913OcYIoHBOCw-- Received: from [63.203.180.122] by web31804.mail.mud.yahoo.com via HTTP; Tue, 17 Apr 2007 12:18:16 PDT Date: Tue, 17 Apr 2007 12:18:16 -0700 (PDT) From: Richard Broersma Jr Subject: Re: Floating point type to store numbers To: radhika@88thstreet.com, pgsql-sql@postgresql.org In-Reply-To: <4838.63.118.86.10.1176836034.squirrel@www.88thstreet.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <504276.57905.qm@web31804.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.696 tagged_above=0 required=5 tests=AWL=-0.060, BAYES_00=-2.599, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447 X-Spam-Level: X-Archive-Number: 200704/153 X-Sequence-Number: 28153 --- > The question is: how accurate is floating point numbers in Postgres. We > are using 7.4 soon to be moving to 8.2. > I need the accuracy to about 6 decimal points. I have read that floating > points can convert to numbers in accurately. http://www.postgresql.org/docs/8.2/interactive/datatype-numeric.html#DATATYPE-FLOAT I didn't see anything about numeric being a string type, http://www.postgresql.org/docs/8.2/interactive/datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL Regards, Richard Broersma Jr.