liquid_feedback_core
diff core.sql @ 484:d264e48cffbf
Sort harmonic_weight of NULL after zero in updated_or_featured_initiative
| author | jbe |
|---|---|
| date | Fri Apr 01 17:24:32 2016 +0200 (2016-04-01) |
| parents | 39f37c2a0c85 |
| children | e431f1b73c35 |
line diff
1.1 --- a/core.sql Fri Apr 01 17:15:12 2016 +0200 1.2 +++ b/core.sql Fri Apr 01 17:24:32 2016 +0200 1.3 @@ -2403,9 +2403,12 @@ 1.4 NOT EXISTS ( 1.5 SELECT NULL FROM "initiative" AS "better_initiative" 1.6 WHERE 1.7 - "better_initiative"."issue_id" = "initiative"."issue_id" AND 1.8 - ("better_initiative"."harmonic_weight", -"better_initiative"."id") > 1.9 - ("initiative"."harmonic_weight", -"better_initiative"."id") 1.10 + "better_initiative"."issue_id" = "initiative"."issue_id" 1.11 + AND 1.12 + ( COALESCE("better_initiative"."harmonic_weight", -1), 1.13 + -"better_initiative"."id" ) > 1.14 + ( COALESCE("initiative"."harmonic_weight", -1), 1.15 + -"better_initiative"."id" ) 1.16 ) AS "leading", 1.17 "initiative".* 1.18 FROM "member" CROSS JOIN "initiative" 1.19 @@ -2502,9 +2505,12 @@ 1.20 NOT EXISTS ( 1.21 SELECT NULL FROM "initiative" AS "better_initiative" 1.22 WHERE 1.23 - "better_initiative"."issue_id" = "initiative"."issue_id" AND 1.24 - ("better_initiative"."harmonic_weight", -"better_initiative"."id") > 1.25 - ("initiative"."harmonic_weight", -"better_initiative"."id") 1.26 + "better_initiative"."issue_id" = "initiative"."issue_id" 1.27 + AND 1.28 + ( COALESCE("better_initiative"."harmonic_weight", -1), 1.29 + -"better_initiative"."id" ) > 1.30 + ( COALESCE("initiative"."harmonic_weight", -1), 1.31 + -"better_initiative"."id" ) 1.32 ) AS "leading", 1.33 "initiative".* 1.34 FROM "member" CROSS JOIN "area"