Peter Nixonn schrieb:
Hi Guys Has anyone written a postgres function to calculate percentages without giving "ERROR: division by zero" when fed zeros?
What is the expected result when you feed zeros? What is your use-case? 0 out of 0 or something? Should that mean 100% or 0%? :-) Or just: Null (as "dont't know") Its easy when you fully know your problem :-) Regards Tino