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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
