Re: Money data type - Deprecated?

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Andrew Sullivan" <ajs(at)commandprompt(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Money data type - Deprecated?
Date: 2008-05-27 13:29:47
Message-ID: b42b73150805270629h309f3704i72c259081d8d393d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, May 26, 2008 at 4:05 PM, Andrew Sullivan <ajs(at)commandprompt(dot)com> wrote:
> On Mon, May 26, 2008 at 03:46:39PM -0400, Justin wrote:
>> Thats a good Question is the Money type ever going to die i believe it was
>> deprecated several versions ago?
>
> I think it was undeprecated in 8.3 because someone (D'Arcy J.M. Cain?)
> made a bunch of changes to the datatype to make it more
> currency-portable. Have a look in the release notes.

Your summary is pretty much correct. The 'deprecated' moniker was for
all intents and purposes removed when the range was expanded. For the
record, I don't agree with this...IMO the money type is not really
rigorous enough to be useful. It's missing tons of basic casts and is
just plain weird. OTOH, it's a neat example of a fixed precision
integer type.

I personally think that it really belongs in contrib as an example of
adding a new type...with all the money bits stripped off, as a
strictly fixed precision integer.

merlin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-05-27 13:57:20 Re: Permission Problem for DELETE
Previous Message Justin Clift 2008-05-27 13:26:35 Re: New MS patent: sounds like PG db rules