[Fwd: Re: HELP ! With Money type] - Mailing list 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