Postgres Pro
Downloads
Home   >   mailing lists

Re: HELP ! With Money type - Mailing list pgsql-admin

From Tom Lane
Subject Re: HELP ! With Money type
Date
Msg-id 19885.1090591980@sss.pgh.pa.us
Whole thread Raw
In response to Re: HELP ! With Money type  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-admin
Tree view 
Oliver Elphick <olly@lfix.co.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

pgsql-admin by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: HELP ! With Money type
Next
From: Peter Eisentraut
Date:
Subject: Re: Seq scan with a like operator