Re: simple division

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: simple division
Дата
Msg-id 627868ba-0d4b-8995-d29a-db6b7ca3673d@gmail.com
обсуждение исходный текст
Ответ на Re: simple division  (Martin Mueller <martinmueller@northwestern.edu>)
Ответы Re: simple division  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Список pgsql-general
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
followinghelpful:
 
>
>
> 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 ;) )





В списке pgsql-general по дате отправления:

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: simple division
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: querying both text and non-text properties