Re: simple division - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: simple division
Date
Msg-id 20181205203727.lo6fadn6ttwyjqia@alvherre.pgsql
Whole thread Raw
In response to Re: simple division  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
List pgsql-general
On 2018-Dec-06, Gavin Flower wrote:

> Calculators normally work in floating point (in fact, as far as I am aware,
> they never work in integer mode by default),

The reason they don't work in "integer mode" is because it doesn't make
sense.

We only have this thing called "integer division" because it's a cheap
thing to implement in terms of machine instructions.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-general by date:

Previous
From: Gavin Flower
Date:
Subject: Re: simple division
Next
From: "Phil Endecott"
Date:
Subject: Limitting full join to one match