"Kevin Grittner" <kevin.gritt...@wicourts.gov> wrote: >>> postgres=# SHOW ME THE MONEY; >>> WARNING: THE MONEY is deprecated in this version of Postgres and >>> may be discarded in a future version >>> HINT: Use SHOW ME THE NUMERIC with the desired precision instead.
>> Funny, but no longer true: >> http://www.postgresql.org/docs/8.4/static/datatype-money.html >> (although I wish we would get rid of the type) > I hadn't been aware it was ever deprecated. It has the advantage > over numeric of using straight integer arithmetic for addition and > subtraction, which are by far the most common operations on money, > while allowing a decimal fraction without rounding problems. I'd > been thinking about migrating our money columns to it (subject to > some benchmarking first, to see how much it actually helped). It > would seem odd for a database to tout its ability to deal with such > data types as geometric shapes and global positioning, etc., which > then didn't have such a common type as money. In my experience, > many business applications deal with money. One major flaw I see is that the fractional precision is fixed. Not only petrol stations split cents. Tim -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
