On 05/12/2018 20:07, Rob Sargent wrote:
On Dec 4, 2018, at 9:33 PM, Gavin Flower <GavinFlower@xxxxxxxxxxxxxxxxx> wrote:
On 05/12/2018 10:51, Rob Sargent wrote:
On 12/4/18 2:36 PM, Martin Mueller wrote:
It worked, and I must have done something wrong. I'm probably not the only person who would find something like the following helpful:
division (integer division truncates the result) 10/3 3
The math types might take offense here, with the use of "truncates". Integer division really ask how many times can one subtract the numerator from the denominator without going negative (or how many times does the numerator "go into" the denominator).
It may seem a nuisance, but int division is a useful construct and must be supported (and be the default). (If you have 10 people to transport in cars which hold four (all can drive) 10/4 = 3 ;) )
Hmm...
10 / 4 = 2
And two are left stranded!
The point is that integer math has its place. You cant have 2.5 cars. So 10/4 in this context is 3.
More correctly the calculation is
10/4 + 10%4>0 ? 1 :0 = 3
(Maybe psql does have % so mod(10,4))
SELECT ceil(10/4.0);
Is what you want for that example.
