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 BFC5DD1B211 for ; Fri, 23 Jul 2004 10:12:27 -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 20123-08 for ; Fri, 23 Jul 2004 13:12:32 +0000 (GMT) Received: from limacorp.com (limacorp.com [69.20.70.38]) by svr1.postgresql.org (Postfix) with SMTP id 1BC41D1B1D5 for ; Fri, 23 Jul 2004 10:12:20 -0300 (ADT) Received: (qmail 5397 invoked by uid 1529); 23 Jul 2004 13:12:30 -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.441954 secs); 23 Jul 2004 13:12:30 -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.441954 secs Process 5392) 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 13:12:29 -0000 Message-ID: <41010DEF.90907@limacorp.com> Date: Fri, 23 Jul 2004 09:09:03 -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 Subject: [Fwd: Re: 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/269 X-Sequence-Number: 14337 All, I found the problem. I see at postrges.org that in 7.4.3 the "money" data type is no longer being used ( deprecated ). I'll replace it with am decimal instead. thanks, Terry Terry Hampton wrote: > > > > 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 -- Terry L. Hampton Project Manager LimaCorp, LLC www.limacorp.com 513.587.1874