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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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