Thread: question about the money type

question about the money type

From
Szymon Guz
Date:
Hi,
in the documentation for 8.2 (http://www.postgresql.org/docs/8.2/interactive/datatype-money.html) there is info:

Note: The money type is deprecated. Use numeric or decimal instead, in combination with theto_char function.

However in later versions the info disappeared. It doesn't exist even in the 8.3.

I think removing this type would a good solution... any plans for that?

What is the status of Money type, is that OK or deprecated?

regards
Szymon

Re: question about the money type

From
Merlin Moncure
Date:
On Wed, Jan 11, 2012 at 9:32 AM, Szymon Guz <mabewlun@gmail.com> wrote:
> Hi,
> in the documentation for 8.2
> (http://www.postgresql.org/docs/8.2/interactive/datatype-money.html) there
> is info:
>
> Note: The money type is deprecated. Use numeric or decimal instead, in
> combination with theto_char function.
>
> However in later versions the info disappeared. It doesn't exist even in the
> 8.3.
>
> I think removing this type would a good solution... any plans for that?
>
> What is the status of Money type, is that OK or deprecated?

in 8.3 it was expanded to 64 bits.  Lack of range was the main reason
for the deprecation so it's status was reverted.  I happen to still
think it's pretty silly to justify as a core type but it's not going
anywhere.

merlin