Re: simple division
Gavin Flower <gavinflower@archidevsys.co.nz>
From: Gavin Flower <GavinFlower@archidevsys.co.nz>
To: Rob Sargent <robjsargent@gmail.com>, pgsql-general@lists.postgresql.org
Date: 2018-12-05T04:33:28Z
Lists: pgsql-general
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