X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9EFEED1B380 for ; Fri, 23 Jul 2004 09:40:04 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 02877-10 for ; Fri, 23 Jul 2004 12:40:09 +0000 (GMT) Received: from limacorp.com (limacorp.com [69.20.70.38]) by svr1.postgresql.org (Postfix) with SMTP id E7665D1B2D9 for ; Fri, 23 Jul 2004 09:39:59 -0300 (ADT) Received: (qmail 4123 invoked by uid 1529); 23 Jul 2004 12:40:07 -0000 Received: from thampton@limacorp.com by garbanzo.limacorp.com by uid 1526 with qmail-scanner-1.22-st-qms (clamdscan: 0.71. spamassassin: 2.63. Clear:RC:1(24.123.167.82):. Processed in 0.442712 secs); 23 Jul 2004 12:40:07 -0000 X-Antivirus-LIMACORP-Mail-From: thampton@limacorp.com via garbanzo.limacorp.com X-Antivirus-LIMACORP: 1.22-st-qms (Clear:RC:1(24.123.167.82):. Processed in 0.442712 secs Process 4118) Received: from rrcs-central-24-123-167-82.biz.rr.com (HELO limacorp.com) (24.123.167.82) by limacorp.com with SMTP; 23 Jul 2004 12:40:06 -0000 Message-ID: <41010659.90908@limacorp.com> Date: Fri, 23 Jul 2004 08:36:41 -0400 From: Terry Hampton User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20021003 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: HELP ! With Money type Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.6 tagged_above=0.0 required=5.0 tests=US_DOLLARS_3 X-Spam-Level: X-Archive-Number: 200407/267 X-Sequence-Number: 14335 Everyone, Just ran across an odd situation. I have defined a field: amount | money | not null default '' Works fine until the dollar amounts get very large - into the tens of millions. At that point, the actual amount stored becomes very unpredictable. I just saved a record via a simple front end App. I entered 56,000,000 When I retrieved the record i got: $13,050,327.04 !! Any thoughts ? ENVIRONMENT: Linux 2.4.20-20.7smp psql (PostgreSQL) 7.2.3 Thank you, Terry -- Terry L. Hampton Project Manager LimaCorp, LLC www.limacorp.com 513.587.1874