Re: simple division

From: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>
To: Rob Sargent <robjsargent(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: simple division
Date: 2018-12-05 04:33:28
Message-ID: 611dee86-118f-df30-a942-2441fc04668f@archidevsys.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2018-12-05 06:05:38 Re: Moving large table between servers: logical replication or postgres_fdw
Previous Message Rhys A.D. Stewart 2018-12-05 03:14:15 Moving large table between servers: logical replication or postgres_fdw