Re: [HACKERS] The Accountant is not Amused

On 1999-12-05, Michael Robinson mentioned:

> template1=> select 9.99::money / 10.0;
> ?column?
> --------
> $1.00   
> (1 row)

You should be using the numeric type. Money is deprecated. What you
pointed out is probably only one of its problems. However, the numeric
type seems to have some ideas of its own as well:

=> select 9.99::numeric(9,2) / 10.0::numeric(9,2);   ?column?
------------
0.9990000000
(1 row)

What are the rules governing this situation?

-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden