getting around---division by zero on numeric
От | Tim Nelson |
---|---|
Тема | getting around---division by zero on numeric |
Дата | |
Msg-id | 43563B8D.7070506@phreaker.net обсуждение исходный текст |
Ответы |
Re: getting around---division by zero on numeric
Re: getting around---division by zero on numeric Re: getting around---division by zero on numeric Re: getting around---division by zero on numeric Re: getting around---division by zero on numeric |
Список | pgsql-general |
I am getting division by zero on a calculated field ( sum(sales) is 0 ) and I can't find a way around this. I figured out you can't use an aggregate in a where, and using having the parser must (obviously) evaluate the select fields before considering teh having clause. Does anyone have a way around this? Thanks! select type, sum(sales), sum(cost), (sum(sales) * sum(cost) / sum(sales)) * 100 from test group by 1 having sum(sales) != 0
В списке pgsql-general по дате отправления: