Re: BUG #5150: math bug

From: John R Pierce <pierce(at)hogranch(dot)com>
To: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #5150: math bug
Date: 2009-10-31 03:51:57
Message-ID: 4AEBB45D.90209@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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>

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Pavel Stehule 2009-10-31 04:37:00 Re: BUG #5154: ERROR: cannot assign non-composite value to a row variable
Previous Message Tom Lane 2009-10-31 03:43:09 Re: BUG #5155: Error compiling postgresql-8.5alpha2