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