Thomas Lockhart writes:
> ...
> > > While browsing the mailing list for an answer to this problem I found
> > > several references to the money type being deprecated. Is that the
> > > problem?
> > They keep saying that DECIMAL should be used instead but they are not
> > exactly equivalent. The MONEY type was originally written with locale
> > support and displays the local currency symbol.
>
> Hmm. If we keep the money type then we should change the internal
> implementation to use numeric or decimal or at least int64 instead of
> int32. Comments?
The purpose of a data type is to store data and attach a semantic value to
it, not to be a tool for presentation. The money type doesn't even do the
former correctly because when you change the locale, the amount stored
changes. Since we have a very fine to_char() function, there is no longer
a need for a separate money type, unless you want to have a type that
stores a number plus a currency unit.
Another reason why I personally consider the money type not very useful is
that the very display format it touts makes it a PITA to parse the output
in client applications.
If you want to have a really silly analogy for why the money type is
wrong, imagine a "length" type, that stores a number, and depending on the
current locale, it prints meters or yards. (Note, it doesn't do the
conversion, it just prints '#### meters' or '#### yards', where #### =
####.) I presume that most people would consider a length type nonsense
in the first place, but that added feature makes it useless.
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter
