Re: rounding problems

From: "Douglas McNaught" <doug(at)mcnaught(dot)org>
To: Justin <justin(at)emproshunts(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: rounding problems
Date: 2008-05-13 16:12:07
Message-ID: 5ded07e00805130912q23835e25x83c4780d9f431e7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2008/5/13 Justin <justin(at)emproshunts(dot)com>:

> Your saying in Excel, Multiplication is not Commutativity??? that sends
> shudders down my back

The word you want in this case is "associative". Since floating point
math is not exact, sometimes the associativity (and other) properties
of some operations are not preserved. This is true for floating point
in general, not just Excel.

-Doug

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Wall 2008-05-13 16:13:33 Re: pg_standby / WAL archive-restore through system restarts
Previous Message Pau Marc Munoz Torres 2008-05-13 16:11:57 too many warnings