pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
[Fwd: Re: HELP ! With Money type] 1+ messages / 1 participants [nested] [flat]
* [Fwd: Re: HELP ! With Money type] @ 2004-07-23 13:09 Terry Hampton <thampton@limacorp.com> 0 siblings, 0 replies; 1+ messages in thread From: Terry Hampton @ 2004-07-23 13:09 UTC (permalink / raw) To: pgsql-admin 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 ^ permalink raw reply [nested|flat] 1+ messages in thread
only message in thread Thread overview: 1+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2004-07-23 13:09 [Fwd: Re: HELP ! With Money type] Terry Hampton <thampton@limacorp.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox