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>