Re: [PATCHES] Fixes for MONEY type using locale - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCHES] Fixes for MONEY type using locale
Date
Msg-id 9506.1196132691@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCHES] Fixes for MONEY type using locale  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: [PATCHES] Fixes for MONEY type using locale  (Bruce Momjian <bruce@momjian.us>)
Re: [PATCHES] Fixes for MONEY type using locale  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
"Joshua D. Drake" <jd@commandprompt.com> writes:
> Well if we are going to continue to support money (which I am against)
> we should support the casting to numeric as that is by far a more
> common implementation of money and we will have mixed environments.

So, you don't use MONEY, and you don't want to, but nonetheless you
know better than the people who do use MONEY what they need.

Aside from the semantic-gap issue, there is the point that providing
a cast might actually mask application errors.  I can well imagine
cases where one of the reasons for using MONEY is *exactly* that it's
not a plain number or easily convertible to one.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: [PATCHES] Fixes for MONEY type using locale
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] Proposed patch for operator lookup caching