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

Re: HELP ! With Money type

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: olly(at)lfix(dot)co(dot)uk
Cc: Terry Hampton <thampton(at)limacorp(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: HELP ! With Money type
Date: 2004-07-23 14:13:00
Message-ID: 19885.1090591980@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Oliver Elphick <olly(at)lfix(dot)co(dot)uk> writes:
> The Money type is deprecated.  It uses a floating point representation,
> which is not good for precise values.

Actually the underlying storage is integer (int4), which is precise but
has a very limited range.  Terry is seeing overflows (which are
evidently not being tested for :-().

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Peter EisentrautDate: 2004-07-23 14:54:33
Subject: Re: Seq scan with a like operator
Previous:From: Negyesi KarolyDate: 2004-07-23 14:07:51
Subject: replication and linux-ha?

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