Subject Re: [firebird-support] why the result is the number commas?
Author Milan Babuskov
W O wrote:
> Never use double precision for money neither for count something, use it
> for measures.

Actually, you can use it to _count_ as long as all individual items are
integers. Double precision is built that way to keep integer arithmetics
clean as long as all operands are integers and results of all
intermediate operations are integers. So:

integer * integer = ok
integer + integer = ok
integer - integer = ok
integer / integer = could present problems

Since _counting_ is only addition, it is safe to do even with double.

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================