Re: cast from integer to money

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Robert Haas" <robertmhaas(at)gmail(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: cast from integer to money
Date: 2011-03-31 22:09:23
Views: Raw Message | Whole Thread | Download mbox
Lists: pgsql-hackers

Robert Haas <robertmhaas(at)gmail(dot)com> wrote:

>> There were reasonable arguments made why this could be a bad idea
>> -- primarily around the question of whether '395' represented
>> $3.95 or $395.00.
> That's not too hard to figure out, right? If 1.00 means $1.00, 1
> had better not mean $0.01, or there will be riots in the streets.
>> Going the other way has issues with truncation of
>> fractions and the number of digits which can be handled.
> Notice I didn't propose that.

If you're just talking about going in the one direction, I might be
persuaded that's sane, especially because of the case of literals,
and especially since there are currencies where fractional amounts
aren't used in the conventional representation.


In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Merlin Moncure 2011-03-31 22:33:02 Re: Process local hint bit cache
Previous Message Bruce Momjian 2011-03-31 21:59:15 Re: Bug in autovacuum.c?