On 06/12/2018 00:05, Geoff Winkless wrote:
> On Wed, 5 Dec 2018 at 09:13, Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz> wrote:
>> SELECT ceil(10/4.0);
>>
>> Is what you want for that example.
> Except that implies that "number of people who can fit in a car" is a
> real number, not a whole.
>
> IMO it's fundamentally broken that SQL doesn't cast the result of a
> divide into a numeric value - the potential for unexpected errors
> creeping into calculations is huge; however that's the standard and
> no-one's going to change it now.
>
> Having said that it's worth noting that those in the Other Place think
> that it's broken enough to go against the standard (they have a DIV b
> for integer divide and a/b for float).
>
> Geoff
>
If you divide one integer by another, then it is logical to get an
integer as as the answer.