Re: Money type todos?

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Money type todos?
Date: 2007-03-21 04:34:39
Message-ID: 4600B5DF.4090008@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane skrev:
>> The money type is considered deprecated. I was also under the impression
>> it would be eventually removed. Why are we accumulating TODOs for it?
>
> Because doing the TODOs would remove the reasons for deprecating it.
>
> Whether it is actually ever going to disappear is not agreed upon.

What is the reason to keep it? The arguments I've seen is that numeric
is too slow to use when you have a lot of money calculations to perform.

But with that argument we should instead make a general artitmetic type
that is fast and useful to more things than just money. Just drop the
currency from money and we have one such type.

Would we accept other money-like types, with other units? Like kilogram,
liter, yards, square meters, and so on? And what use is the unit in
money? It's not like it will do currency conversion or anything like that.

I think money should go away and the database should provide more
general types.

/Dennis

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-03-21 05:50:06 Re: patch adding new regexp functions
Previous Message Bruce Momjian 2007-03-21 02:36:57 Re: CREATE INDEX and HOT - revised design