Skip site navigation (1) Skip section navigation (2)

Re: dividing money by money

From: Andy Balholm <andy(at)balholm(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: dividing money by money
Date: 2010-04-01 00:45:13
Message-ID: E96D6D38-4D6A-4B19-892B-0E0FFF555D17@balholm.com (view raw or flat)
Thread:
Lists: pgsql-bugs
> That's hardly an improvement if you're concerned about lack of
> exactness.

I know; I lose a couple of digits by using float8 instead of numeric, but it's much simpler and faster, and if it returned numeric people would _think_ it was exact.

And if we have a cast to numeric, people who want those extra digits can cast to numeric before dividing.

But I do still have the numeric code that I tried, so if that's how people want to do it, I can provide it.

In response to

Responses

pgsql-bugs by date

Next:From: Takahiro ItagakiDate: 2010-04-01 00:53:42
Subject: Re: BUG #5398: psql gives syntax error on .sql files with UTF-8 BOM
Previous:From: Tom LaneDate: 2010-03-31 22:50:08
Subject: Re: dividing money by money

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group