[samigo-team] Floating point numbers

Sam Ottenhoff ottenhoff at longsight.com
Thu Feb 28 06:11:46 PST 2013


> But just curious, what is the advantage of this change? Is this for
> getting a more precise score? Like some 0.999 issue?
>

An instructor created a complex placement exam that used point scores in
the millions, thousands, hundreds, etc. as a way of being able to quickly
see points in various sections in the final score (example: 27005508.06
could be broken up to see that the student scores 06 on sec 1, 08, on sec
2, 55 on sec 3, 27 on sec 4).

So the reason why floating point numbers aren't used for money:

> create table floattest (z float);
> insert into floattest VALUES (*2075808*);
> select * from floattest;

The result: *2075810*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/samigo-team/attachments/20130228/1d1fa6ab/attachment-0001.html 


More information about the samigo-team mailing list