Horton

Re: BUG #5150: math bug

Robert Haas <robertmhaas@gmail.com>

View thread View on postgr.es
From: Robert Haas <robertmhaas@gmail.com>
To: John R Pierce <pierce@hogranch.com>
Cc: PostgreSQL Bugs <pgsql-bugs@postgresql.org>
Date: 2009-10-31T13:10:56Z
Lists: pgsql-bugs 
On Fri, Oct 30, 2009 at 11:51 PM, John R Pierce <pierce@hogranch.com> wrote:
> 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>

That's true.  Nobody said otherwise.

...Robert