Re: Money data type - Deprecated?

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Money data type - Deprecated?
Дата
Msg-id b42b73150805270629h309f3704i72c259081d8d393d@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Money data type - Deprecated?  (Andrew Sullivan <ajs@commandprompt.com>)
Ответы Re: Money data type - Deprecated?
Список pgsql-general
On Mon, May 26, 2008 at 4:05 PM, Andrew Sullivan <ajs@commandprompt.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

В списке pgsql-general по дате отправления:

Предыдущее
От: "A B"
Дата:
Сообщение: Annoying messages when copy sql code to psql terminal
Следующее
От: Justin Clift
Дата:
Сообщение: Re: New MS patent: sounds like PG db rules