> On Dec 4, 2018, at 9:33 PM, Gavin Flower <gavinflo...@archidevsys.co.nz>
> 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))