liquid_feedback_core

diff core.sql @ 316:727926e290e7
Set "harmonic_weight" to zero instead of null, where there are no supporters
author: jbe
date: Sat Feb 02 20:21:16 2013 +0100 (2013-02-02)
parents: 5289d62c028c
children: 09e2805decd3
     1.1 --- a/core.sql	Fri Feb 01 20:14:43 2013 +0100
     1.2 +++ b/core.sql	Sat Feb 02 20:21:16 2013 +0100
     1.3 @@ -3158,6 +3158,8 @@
     1.4            "i" := "i" + 1;
     1.5          END LOOP;
     1.6        END LOOP;
     1.7 +      UPDATE "initiative" SET "harmonic_weight" = 0
     1.8 +        WHERE "issue_id" = "issue_id_p" AND "harmonic_weight" ISNULL;
     1.9      END;
    1.10    $$;
    1.11  
    1.12 @@ -3268,6 +3270,8 @@
    1.13            "i" := "i" + 1;
    1.14          END LOOP;
    1.15        END LOOP;
    1.16 +      UPDATE "suggestion" SET "harmonic_weight" = 0
    1.17 +        WHERE "initiative_id" = "initiative_id_p" AND "harmonic_weight" ISNULL;
    1.18      END;
    1.19    $$;
    1.20