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:
Any thoughts ?
psql (PostgreSQL) 7.2.3
Terry L. Hampton
LimaCorp, LLC www.limacorp.com
pgsql-admin by date
|Next:||From: Jouneau Luc||Date: 2004-07-23 12:50:42|
|Subject: Seq scan with a like operator|
|Previous:||From: Eduardo S. Fontanetti||Date: 2004-07-23 12:24:06|