Never use double precision for money neither for count something, use it
for measures.

Greetings.

Walter.

On Sat, Jun 2, 2012 at 2:06 PM, Mark Rotteveel <mark@...> wrote:

> **
>
>
> On 2-6-2012 19:47, softdestek wrote:
> > ACCOUNTS.DEBT is double
> > ACCOUNTS.RECEIVABLES is double
> >
> > MY QUERY
> > SELECT
> > SUM(ACCOUNTS.DEBT),
> > SUM(ACCOUNTS.RECEIVABLES),
> > sum(ACCOUNTS.DEBT)-SUM(ACCOUNTS.RECEIVABLES)
> > FROM ACCOUNTS
> > WHERE ACCOUNTS.CODE='100'
> >
> >
> >
> > 1) SQL RESULT
> > SUM(ACCOUNTS.DEBT) 2708021,63
> > 2) SQL RESULT
> > SUM(ACCOUNTS.RECEIVABLES) 2707357,52
> > the correct result=664,11
> >
> > 3)SQL RESULT
> > sum(ACCOUNTS.DEBT)-SUM(ACCOUNTS.RECEIVABLES) 664,109999998938
> > Why is this?
> > Why is there a difference between the two results?
>
> Double precision is not exact due to the way it represents numbers, see
> http://docs.oracle.com/cd/E19957-01/806-3568/ncg_goldberg.html for a
> thorough explanation.
>
> Mark
>
> --
> Mark Rotteveel
>
>
>


[Non-text portions of this message have been removed]