HELP ! With Money type

    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