Division By Zero

19 Jun 2015

      I might be doing something wrong, but should this really throw a division by zero?

SELECT 
    count(*) / ((max("end")-min(start)) / 60)
FROM    table 
GROUP BY s
HAVING max("end")-min(start)<>0 ;

Strangely enough, this works:

SELECT
    count(*) / ((max("end")-min(start)))
FROM    table
GROUP BY s
HAVING max("end")-min(start)<>0;

Am I doing something wrong?

Thanks

  Raffael

— 

 Visual Analytics Workshop at #BlackHat US in August:   http://bit.ly/1FN1W5e
 Raffael Marty
 ceo @ pixlcloud                                        http://pixlcloud.com
 @raffaelmarty                                          http://raffy.ch