Re: simple division - Mailing list pgsql-general

From Raymond Brinzer
Subject Re: simple division
Date
Msg-id CANasJHk9dS3yFQqVyKf+13StfbD4GWsypoGp_kaM+Y9_jbGXPw@mail.gmail.com
Whole thread Raw
In response to Re: simple division  (Geoff Winkless <pgsqladmin@geoff.dj>)
List pgsql-general


On Wed, Dec 5, 2018 at 7:55 AM Geoff Winkless <pgsqladmin@geoff.dj> wrote:
Where's the logical progression in step 3 here:

1 You asked the computer a question

2 The values you passed to it don't have decimal points

...

4 Ergo, you wanted an answer that was incorrect.

Well put.  However the nature of the question you asked does not necessarily allow for a correct finite answer.  If I ask for 10/3, for instance, or 1/0.  To play devil's advocate, then:  you should have known that some of the answers would need to be truncated.  This just truncates a little more aggressively.  ;-)

--
Ray Brinzer

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: simple division
Next
From: Rob Nikander
Date:
Subject: Re: querying both text and non-text properties