Re: Does bug 2921 justify a version 3.19.4?

[Benoît Minisini <benoit.minisini@xxxxxxxxxxxxxxxx>]

Le 04/08/2024 à 13:56, Gianluigi a écrit :
> Il 04/08/24 12:15, Christof Thalhofer ha scritto:
> > Hi,
> >
> > I think so, because if Gambas in combination with PG doesn't count right
> > it can have ugly consequences.
> >
> > Bug 2921: Postgresql 19.900000000000055 is 20 in Gambas
> >
> > Alles Gute
> >
> > Christof Thalhofer
>
> Hi Christof and Benoit,
>
> I'm referring to what is in question and Christof's comment on the
> bugtracker  (Wow cool, thank you! The discussion even made me doubt my
> own thinking. Good, that it's fixed!)
> At this point I'm the one who's perplexed, I've always believed that to
> manage the currency in Gambas it would be necessary to save the amounts
> as integers, right?
> How should numbers representing amounts be saved?
>
> Thank you
> Gianluigi

You should normally use an integer that will store your currency 
multiplied by 10^N, N being the number of decimals you need.

You do that to avoid rounding errors when doing computations, or 
printing currency (converting them to string).

You can use floating points, but you will be prone to rounding errors 
with decimals, as 1/10 cannot be represented in binary.

Of course it makes the management a bit more complex when doing 
conversion between currency and strings.

Regards,

--
Benoît Minisini.