On 9/29/05, Ralf Junker <[EMAIL PROTECTED]> wrote: > > Another problem shows when calculations are not performed on colums with > type affinity but just on plain numbers like in > > SELECT 5 / 2; > > What exactly is intended? From the findings above, both numbers might be > seen as INTEGERs, but if '5.0' is interpreted as an INTEGER above, '5' > might just as well be a REAL. >
As per almost every interpreted language standard 5 is an integer. 5.0 is a float. As you proved with your own example 5.0 is not interpreted as an integer.