1.1 --- a/core.sql	Sun Apr 03 19:57:11 2016 +0200
     1.2 +++ b/core.sql	Sun Apr 03 20:00:20 2016 +0200
     1.3 @@ -3127,13 +3127,13 @@
     1.4              "last_suggestion_id_v" )
     1.5            ON CONFLICT ("member_id", "initiative_id") DO UPDATE SET
     1.6              "last_draft_id" = CASE
     1.7 -              WHEN "last_draft_id" > "last_draft_id_v"
     1.8 -              THEN "last_draft_id"
     1.9 +              WHEN "initiative_notification_sent"."last_draft_id" > "last_draft_id_v"
    1.10 +              THEN "initiative_notification_sent"."last_draft_id"
    1.11                ELSE "last_draft_id_v"
    1.12              END,
    1.13              "last_suggestion_id" = CASE
    1.14 -              WHEN "last_suggestion_id" > "last_suggestion_id_v"
    1.15 -              THEN "last_suggestion_id"
    1.16 +              WHEN "initiative_notification_sent"."last_suggestion_id" > "last_suggestion_id_v"
    1.17 +              THEN "initiative_notification_sent"."last_suggestion_id"
    1.18                ELSE "last_suggestion_id_v"
    1.19              END;
    1.20          RETURN NEXT "result_row";