Re: monetary data type - Mailing list pgsql-general

From Tom Lane
Subject Re: monetary data type
Date
Msg-id 7526.986596275@sss.pgh.pa.us
Whole thread Raw
In response to monetary data type  (Phuong Ma <pma@commandprompt.com>)
List pgsql-general
Phuong Ma <pma@commandprompt.com> writes:
> I read this from the 7.1 documentation:
> 3.2. Monetary Type

> The money type may become a locale-aware
> layer over the numeric type in a future release.

> The money type stores U.S.-style currency with fixed decimal point
> representation. If Postgres is compiled with locale support then the
> money type uses locale-specific output formatting.

> ----------
> Why does this first say that the money type may become locale-aware in a
> FUTURE release, then the next paragraph says that the money type USES
> locale  specific output formatting.  So which one is it?

In that sentence, "locale-aware" is an adjective modifying "layer".
It does not say that the current implementation is not locale-aware;
it says that it's not based on numeric.

> Why would it
> be better to use numeric or decimal rather than money data type?

Overflow.

            regards, tom lane

pgsql-general by date:

Previous
From: "Gordon A. Runkle"
Date:
Subject: How much log space does VACUUM need?
Next
From: Tom Lane
Date:
Subject: Re: How much log space does VACUUM need?