Re: BUG #5150: math bug
John R Pierce <pierce@hogranch.com>
From: John R Pierce <pierce@hogranch.com>
To: PostgreSQL Bugs <pgsql-bugs@postgresql.org>
Date: 2009-10-31T03:51:57Z
Lists: pgsql-bugs
Tom Lane wrote: > There is special-purpose software out there that can compute exactly > with rational numbers, but you aren't likely to find it embedded in any > general-purpose tools like databases --- the use-case just isn't wide > enough. One reason why not is that it'll still fall down on irrational > numbers. > <nit> 1/3 is a rational number. however, it is a repeating fraction when expressed in decimal. </nit>