Re: [PATCHES] Fixes for MONEY type using locale

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCHES] Fixes for MONEY type using locale
Date: 2007-11-27 03:04:51
Message-ID: 9506.1196132691@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

"Joshua D. Drake" <jd(at)commandprompt(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2007-11-27 04:12:07 Re: [PATCHES] Proposed patch for operator lookup caching
Previous Message Joshua D. Drake 2007-11-27 02:42:39 Re: [PATCHES] Fixes for MONEY type using locale

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2007-11-27 04:12:07 Re: [PATCHES] Proposed patch for operator lookup caching
Previous Message Joshua D. Drake 2007-11-27 02:42:39 Re: [PATCHES] Fixes for MONEY type using locale