Search Postgresql Archives

Re: Money data type - Deprecated?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On May 27, 2008, at 8:29 AM, Merlin Moncure wrote:
On Mon, May 26, 2008 at 4:05 PM, Andrew Sullivan <ajs@xxxxxxxxxxxxxxxxx> 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.

I think what it really needs is currency information so that you can tell if a value is in USD or something else. But it seems that every time that's brought up, people want to start worrying about storing conversion tables.
--
Decibel!, aka Jim C. Nasby, Database Architect  decibel@xxxxxxxxxxx
Give your computer some brain candy! www.distributed.net Team #1828


<<attachment: smime.p7s>>


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux