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