| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Martin Mueller <martinmueller(at)northwestern(dot)edu> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: a very primitive question about division |
| Date: | 2018-03-07 17:43:20 |
| Message-ID: | CAKFQuwbb7e_jXLxxY83-=WV-jQ_97MvOe-kH5J3KFv0H-bpNnQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Mar 7, 2018 at 10:30 AM, Martin Mueller <
martinmueller(at)northwestern(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martin Mueller | 2018-03-07 17:56:55 | Re: a very primitive question about division |
| Previous Message | Martin Mueller | 2018-03-07 17:30:42 | Re: a very primitive question about division |