Skip site navigation (1) Skip section navigation (2)

[Fwd: Re: HELP ! With Money type]

From: Terry Hampton <thampton(at)limacorp(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: [Fwd: Re: HELP ! With Money type]
Date: 2004-07-23 13:09:03
Message-ID: 41010DEF.90907@limacorp.com (view raw or flat)
Thread:
Lists: 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



pgsql-admin by date

Next:From: Oliver ElphickDate: 2004-07-23 13:20:43
Subject: Re: HELP ! With Money type
Previous:From: Jouneau LucDate: 2004-07-23 12:50:42
Subject: Seq scan with a like operator

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group