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
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 |