Re: Money casting too liberal?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Money casting too liberal?
Date: 2013-03-28 21:36:04
Message-ID: 5154B7C4.5020401@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3/28/2013 2:13 PM, D'Arcy J.M. Cain wrote:
> I would have rather made that part of the column definition similar to
> how we create timestamps with or without timezones. If a column is
> tracking Yen it should always be Yen. Y10,000 should never display as
> $100.00 just because the locale changes.

or to another extreme, part of the data, such that different rows could
have different monetary units. (eg, money is implemented as a pair
(currency,amount). eeek, then you'd need exchange rate tables and
such. hahahahaha, what a nightmare.

--
john r pierce 37N 122W
somewhere on the middle of the left coast

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jasen Betts 2013-03-28 21:36:18 Re: Understanding behavior of SELECT with multiple unnested columns
Previous Message D'Arcy J.M. Cain 2013-03-28 21:13:07 Re: Money casting too liberal?