Horton

Re: a very primitive question about division

David G. Johnston <david.g.johnston@gmail.com>

View thread View on postgr.es
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Martin Mueller <martinmueller@northwestern.edu>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2018-03-07T17:43:20Z
Lists: pgsql-general 
On Wed, Mar 7, 2018 at 10:30 AM, Martin Mueller <
martinmueller@northwestern.edu> wrote:

> Thanks.  So  round(before1550/colfreq::numeric, 2)  produces the desired
> result.
>
>
>
> The explanations and examples of string functions in the Postgres
> documentation are a model of clarity. The explanations and examples of
> basic arithmetic operations  are not.  There is room for improvement there.
>
>
>
Possibly.  Patches (or even just email suggestions - though the former are
generally more apt to get applied) detailing specific improvements to make
are welcome.

The description "division (integer division truncates the result)" seems
reasonably clear - if you don't want the result truncated, and have two
integers, you have to make one of the inputs a non-integer.  Of the various
options I tend to choose numeric though others are possible.

David J.