Re: dividing money by money

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andy Balholm <andy(at)balholm(dot)com>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: dividing money by money
Date: 2010-03-31 22:50:08
Message-ID: 29900.1270075808@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Andy Balholm <andy(at)balholm(dot)com> writes:
> I tried rewriting my function to use numeric, but I discovered that numeric division is not exact. (Otherwise SELECT 1::numeric / 3::numeric would result in an infinite loop.) So I went back to my float8 version and wrote a cast from money to numeric.

That's hardly an improvement if you're concerned about lack of
exactness.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andy Balholm 2010-04-01 00:45:13 Re: dividing money by money
Previous Message Andy Balholm 2010-03-31 22:35:29 Re: dividing money by money