[Info-ingres] precision

[Paul White]

Agreed. Perhaps this financial ledger was designed with scientific purposes
in mind.


I was thinking of borrowing from Orwell.
Some numbers are more equal than others.



-----Original Message-----
From: info-ingres-bounces at lists.planetingres.org
[mailto:info-ingres-bounces at lists.planetingres.org] On Behalf Of Roy Hann
Sent: Thursday, 15 November 2018 11:55 PM
To: Paul White; 'Ingres and related product discussion forum'
Subject: Re: [Info-ingres] precision

Thursday, November 15, 2018, 1:51:01 PM, you wrote:

> Yep worked a treat. Thanks Roy.

> I was getting satisfaction from this but I think it has quite a bit more
> overhead.

Generally tests involving floats should be done in terms of an
acceptable error (sometimes referred to as epsilon). e.g.

... having abs(sum(source_amount))-float4(0.01) < float4(.00001)

Roy Hann
Rational Commerce Ltd.
T +44 20 8691 2089
"Ingres development, tuning and training experts"

_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org
https://lists.planetingres.org/mailman/listinfo/info-ingres