Re: simple division - Mailing list pgsql-general

From Gavin Flower
Subject Re: simple division
Date
Msg-id 611dee86-118f-df30-a942-2441fc04668f@archidevsys.co.nz
Whole thread Raw
In response to Re: simple division  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: simple division
List 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




pgsql-general by date:

Previous
From: "Rhys A.D. Stewart"
Date:
Subject: Moving large table between servers: logical replication or postgres_fdw
Next
From: Rob Sargent
Date:
Subject: Re: Moving large table between servers: logical replication or postgres_fdw