On lör, 2010-07-17 at 07:20 -0700, Andy Balholm wrote: > On Jul 17, 2010, at 3:20 AM, Peter Eisentraut wrote: > > > On fre, 2010-07-16 at 10:31 -0400, Tom Lane wrote: > >> The other argument that I found convincing was that if the > >> operator was defined to yield numeric, people might think that > >> the result was exact ... which of course it won't be, either way. > >> Choosing float8 helps to remind the user it's an approximate quotient. > > > > Why is it approximate? Aren't money values really integers? > > $1.00 / 3.00 = 0.333333333333333333333333333333333333333333333333...
By that reasoning, numeric / numeric should also yield float. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers