liquid_feedback_core
diff core.sql @ 433:603f6e4bbedf
Bugfix in "close_voting" function that only affected PostgreSQL versions prior 9.1
author | jbe |
---|---|
date | Wed Jun 11 00:34:12 2014 +0200 (2014-06-11) |
parents | a1031e47760b |
children | 34cc98defa8b |
line diff
1.1 --- a/core.sql Thu May 22 12:40:30 2014 +0200 1.2 +++ b/core.sql Wed Jun 11 00:34:12 2014 +0200 1.3 @@ -3777,7 +3777,7 @@ 1.4 JOIN "vote" AS "agg" 1.5 ON "initiative"."id" = "agg"."initiative_id" 1.6 AND "vote"."member_id" = "agg"."member_id" 1.7 - GROUP BY "vote"."initiative_id", "vote"."member_id" 1.8 + GROUP BY "vote"."initiative_id", "vote"."member_id", "vote"."grade" 1.9 ) AS "subquery" 1.10 WHERE "vote"."issue_id" = "issue_id_p" 1.11 AND "vote"."initiative_id" = "subquery"."initiative_id"