Re: simple division
От | David G. Johnston |
---|---|
Тема | Re: simple division |
Дата | |
Msg-id | CAKFQuwZ-OXBEXjLa0i_1SwyiiiEwMcfuhZyC3cpe2aKZRpcJag@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: simple division (Martin Mueller <martinmueller@northwestern.edu>) |
Ответы |
Re: simple division
|
Список | 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 по дате отправления: