On 12/4/18 12:29 PM, Martin Mueller wrote:
I have asked this question before and apologize for not remembering
it. How do you do simple division in postgres and get 10/4 with decimals?
This involves cast and numeric in odd ways that are not well explained
in the documentation. For instance, you’d expect an example in the
Mathematical Functions. But there isn’t.
The documentation of string functions is exemplary. The documentation
of mathematical less so. Remember that it may be used by folks like me
whose math is shaky. The MySQL documentation is better on this simple
operation.
I may be misunderstanding the question but:
select cast(x/y as numeric(10,4));
JD
-----
Martin Mueller
Professor emeritus of English and Classics
Northwestern University
--
Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc
*** A fault and talent of mine is to tell it exactly how it is. ***
PostgreSQL centered full stack support, consulting and development.
Advocate: @amplifypostgres || Learn: https://postgresconf.org
***** Unless otherwise stated, opinions are my own. *****
