On Thu, Mar 31, 2011 at 4:58 PM, Kevin Grittner <kevin.gritt...@wicourts.gov> wrote: > Robert Haas <robertmh...@gmail.com> wrote: >> On the open items list, we have: >> >> conversion from integer literals to money type >> http://archives.postgresql.org/pgsql-testers/2011-01/msg00000.php >> >> What this is really complaining about is that we added a cast from >> numeric to money, but not from integer to money. This isn't >> really a bug: the fact that we added one cast doesn't oblige us to >> add two. On the other hand, the change is probably harmless and >> straightforward, and might reduce user confusion. > > 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. > I'm not > convinced it's sane, and I feel strongly it's too late in the cycle > to try to implement. Fair enough. Any contrary votes? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers