liquid_feedback_core
diff update/core-update.v2.2.0-v2.2.1.sql @ 378:e88d0606891f
Bugfix regarding "proportional_order" of suggestions:
Use NULL values explicitly to be sorted last
(includes new suggestions as well as suggestions without any individual rankings)
Use NULL values explicitly to be sorted last
(includes new suggestions as well as suggestions without any individual rankings)
author | jbe |
---|---|
date | Mon Mar 18 09:36:21 2013 +0100 (2013-03-18) |
parents | 47965760b1b8 |
children |
line diff
1.1 --- a/update/core-update.v2.2.0-v2.2.1.sql Mon Mar 18 09:24:51 2013 +0100 1.2 +++ b/update/core-update.v2.2.0-v2.2.1.sql Mon Mar 18 09:36:21 2013 +0100 1.3 @@ -8,7 +8,7 @@ 1.4 COMMENT ON COLUMN "initiative"."final_suggestion_order_calculated" IS 'Set to TRUE, when "proportional_order" of suggestions has been calculated the last time'; 1.5 1.6 ALTER TABLE "suggestion" ADD COLUMN "proportional_order" INT4; 1.7 -COMMENT ON COLUMN "suggestion"."proportional_order" IS 'To be used for sorting suggestions within an initiative; updated by "lf_update_suggestion_order"'; 1.8 +COMMENT ON COLUMN "suggestion"."proportional_order" IS 'To be used for sorting suggestions within an initiative; NULL values sort last; updated by "lf_update_suggestion_order"'; 1.9 1.10 CREATE VIEW "initiative_suggestion_order_calculation" AS 1.11 SELECT