1.1 --- a/core.sql	Wed Jun 20 21:22:02 2012 +0200
     1.2 +++ b/core.sql	Fri Oct 05 11:41:51 2012 +0200
     1.3 @@ -7,7 +7,7 @@
     1.4  BEGIN;
     1.5  
     1.6  CREATE VIEW "liquid_feedback_version" AS
     1.7 -  SELECT * FROM (VALUES ('2.0.11', 2, 0, 11))
     1.8 +  SELECT * FROM (VALUES ('2.0.12', 2, 0, 12))
     1.9    AS "subquery"("string", "major", "minor", "revision");
    1.10  
    1.11  
    1.12 @@ -2796,37 +2796,6 @@
    1.13  
    1.14  
    1.15  
    1.16 -------------------------------
    1.17 --- Comparison by vote count --
    1.18 -------------------------------
    1.19 -
    1.20 -CREATE FUNCTION "vote_ratio"
    1.21 -  ( "positive_votes_p" "initiative"."positive_votes"%TYPE,
    1.22 -    "negative_votes_p" "initiative"."negative_votes"%TYPE )
    1.23 -  RETURNS FLOAT8
    1.24 -  LANGUAGE 'plpgsql' STABLE AS $$
    1.25 -    BEGIN
    1.26 -      IF "positive_votes_p" > 0 AND "negative_votes_p" > 0 THEN
    1.27 -        RETURN
    1.28 -          "positive_votes_p"::FLOAT8 /
    1.29 -          ("positive_votes_p" + "negative_votes_p")::FLOAT8;
    1.30 -      ELSIF "positive_votes_p" > 0 THEN
    1.31 -        RETURN "positive_votes_p";
    1.32 -      ELSIF "negative_votes_p" > 0 THEN
    1.33 -        RETURN 1 - "negative_votes_p";
    1.34 -      ELSE
    1.35 -        RETURN 0.5;
    1.36 -      END IF;
    1.37 -    END;
    1.38 -  $$;
    1.39 -
    1.40 -COMMENT ON FUNCTION "vote_ratio"
    1.41 -  ( "initiative"."positive_votes"%TYPE,
    1.42 -    "initiative"."negative_votes"%TYPE )
    1.43 -  IS 'Returns a number, which can be used for comparison of initiatives based on count of approvals and disapprovals. Greater numbers indicate a better result. This function is NOT injective.';
    1.44 -
    1.45 -
    1.46 -
    1.47  ------------------------------------------------
    1.48  -- Locking for snapshots and voting procedure --
    1.49  ------------------------------------------------
    1.50 @@ -4054,7 +4023,6 @@
    1.51            WHERE "issue_id" = "issue_id_p" AND "eligible"
    1.52            ORDER BY
    1.53              "schulze_rank",
    1.54 -            "vote_ratio"("positive_votes", "negative_votes"),
    1.55              "id"
    1.56            LIMIT 1
    1.57          ) AS "subquery"
    1.58 @@ -4069,7 +4037,6 @@
    1.59            "winner" DESC,
    1.60            "eligible" DESC,
    1.61            "schulze_rank",
    1.62 -          "vote_ratio"("positive_votes", "negative_votes"),
    1.63            "id"
    1.64        LOOP
    1.65          UPDATE "initiative" SET "rank" = "rank_v"