| 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
| 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 |