On Wed, 5 Dec 2018 at 09:13, Gavin Flower <gavinflo...@archidevsys.co.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
