From: | Andreas Karlsson <andreas(at)proxel(dot)se> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andrew Dunstan <andrew(at)dunslane(dot)net> |
Cc: | Jaime Casanova <jaime(at)2ndquadrant(dot)com>, Andres Freund <andres(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Josh Berkus <josh(at)agliodbs(dot)com> |
Subject: | Re: Let's drop two obsolete features which are bear-traps for novices |
Date: | 2014-11-04 14:35:03 |
Message-ID: | 5458E417.8030708@proxel.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 11/02/2014 06:41 PM, Tom Lane wrote:
> I wrote:
>> Either way, requiring a dump/reload for upgrade is surely a better answer
>> for users of the type than just summarily screwing them.
>
> BTW, after reflecting a bit more I'm less than convinced that this
> datatype is completely useless. Even if you prefer to store currency
> values in numeric columns, casting to or from money provides a way to
> accept or emit values in whatever monetary format the LC_MONETARY locale
> setting specifies. That seems like a useful feature, and it's one you
> could not easily duplicate using to_char/to_number (not to mention that
> those functions aren't without major shortcomings of their own).
I personally find that one of the money type's missfeatures, since the
currency symbol does not vary just per language/locale but also for
which currency you are working with. For databases with multiple
currencies the output format of money is just confusing.
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2014-11-04 14:35:14 | Re: Let's drop two obsolete features which are bear-traps for novices |
Previous Message | Kevin Grittner | 2014-11-04 14:16:40 | Re: Let's drop two obsolete features which are bear-traps for novices |