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>