Tag: divide-by-zero

Avoid division by zero in PostgreSQL

aggregate-functions divide-by-zero null postgresql sql

I’d like to perform division in a SELECT clause. When I join some tables and use aggregate function I often have either null or zero values as the dividers. As for now I only come up with this method …