Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id C227E632B9D for ; Fri, 12 Mar 2010 04:10:34 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 98117-07 for ; Fri, 12 Mar 2010 08:10:24 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mx3.wp.pl (mx3.wp.pl [212.77.101.7]) by mail.postgresql.org (Postfix) with ESMTP id 153AF63237B for ; Fri, 12 Mar 2010 04:10:23 -0400 (AST) Received: (wp-smtpd smtp.wp.pl 11813 invoked from network); 12 Mar 2010 09:10:21 +0100 Received: from abbm103.neoplus.adsl.tpnet.pl (HELO [127.0.0.1]) (ipluta@[83.6.202.103]) (envelope-sender ) by smtp.wp.pl (WP-SMTPD) with AES256-SHA encrypted SMTP for ; 12 Mar 2010 09:10:21 +0100 Message-ID: <4B99F6E9.7000407@wp.pl> Date: Fri, 12 Mar 2010 09:10:17 +0100 From: Ireneusz Pluta User-Agent: Thunderbird 2.0.0.24 (Windows/20100228) MIME-Version: 1.0 To: Jasen Betts CC: pgsql-sql@postgresql.org Subject: Re: Clarification With Money data type References: <4e98ec861003092319q457aa3camb9b4bcd36cfbfc15@mail.gmail.com> In-Reply-To: Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-WP-AV: skaner antywirusowy poczty Wirtualnej Polski S. A. X-WP-SPAM: NO 0000000 [0YOk] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.141 tagged_above=-10 required=5 tests=BAYES_00=-2.599, HTML_MESSAGE=0.001, MIME_HTML_ONLY=1.457 X-Spam-Level: X-Archive-Number: 201003/65 X-Sequence-Number: 33772 

 it's better to use some sort of numeric
or integer and store amounts of cents, not dollars.