liquid_feedback_frontend

changeset 267:bed32bf10a0b
Fixed error when listing issues with zero population
author: bsw
date: Tue Feb 07 19:25:55 2012 +0100 (2012-02-07)
parents: aab7b0c5543f
children: 1f7b38584c0d
files: app/main/initiative/_list.lua
     1.1 --- a/app/main/initiative/_list.lua	Tue Feb 07 19:25:29 2012 +0100
     1.2 +++ b/app/main/initiative/_list.lua	Tue Feb 07 19:25:55 2012 +0100
     1.3 @@ -150,7 +150,7 @@
     1.4      if issue.ranks_available then
     1.5        initiatives_selector:add_order_by("initiative.rank, initiative.admitted DESC, vote_ratio(initiative.positive_votes, initiative.negative_votes) DESC, initiative.id")
     1.6      else
     1.7 -      initiatives_selector:add_order_by("initiative.supporter_count::float / issue.population::float DESC, initiative.id")
     1.8 +      initiatives_selector:add_order_by("CASE WHEN issue.population = 0 THEN 0 ELSE initiative.supporter_count::float / issue.population::float END DESC, initiative.id")
     1.9      end
    1.10    end
    1.11