question about the money type

Lists: pgsql-general
From: Szymon Guz <mabewlun(at)gmail(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: question about the money type
Date: 2012-01-11 15:32:34
Message-ID: CAFjNrYu4QHbFhYeO=97hFQfLdO2wbnULKFK4OxF-fgJS8JV-7A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

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

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Szymon Guz <mabewlun(at)gmail(dot)com>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: question about the money type
Date: 2012-01-11 16:49:03
Message-ID: CAHyXU0zYLLZqqNnprAvpojVPQJciCZZJGZRbRpHX4a2j5VEiFQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

On Wed, Jan 11, 2012 at 9:32 AM, Szymon Guz <mabewlun(at)gmail(dot)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