Re: simple division - Mailing list pgsql-general

From David G. Johnston
Subject Re: simple division
Date
Msg-id CAKFQuwZ-OXBEXjLa0i_1SwyiiiEwMcfuhZyC3cpe2aKZRpcJag@mail.gmail.com
Whole thread Raw
In response to Re: simple division  (Martin Mueller <martinmueller@northwestern.edu>)
Responses Re: simple division
List pgsql-general
On Tue, Dec 4, 2018 at 1:57 PM Martin Mueller
<martinmueller@northwestern.edu> wrote:
>
> I didn't formulate my question properly, because the query went like
>  "select alldefects /wordcount"
> where alldefects and wordcount are integers.   But none of the different ways of putting the double colon seemed to
work.

IDK...the first thing that came to mind was to just stick it at the
end of the expression:

select x/y::numeric from (values (10,4)) vals (x,y)

And it worked...

If you want to propose a concrete documentation patch more power to
you but this doesn't come up enough to think that what we have is
materially deficient.  I'm sorry you are having trouble with it but
the lists do provide quick and customized answers for situations like
this.

David J.


pgsql-general by date:

Previous
From: Martin Mueller
Date:
Subject: Re: simple division
Next
From: Ron
Date:
Subject: Re: simple division