Skip to content

Instantly share code, notes, and snippets.

@jherdman
Created December 23, 2014 16:34
Show Gist options
  • Save jherdman/7b89dcd9ac79b2357c4e to your computer and use it in GitHub Desktop.
Save jherdman/7b89dcd9ac79b2357c4e to your computer and use it in GitHub Desktop.
diff --git a/db/structure.sql b/db/structure.sql
index 81578f2..7c67a5c 100644
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -638,7 +638,7 @@ CREATE VIEW completion_rate AS
SELECT activity_state_count.membership_id,
sum(activity_state_count.count) AS completed
FROM activity_state_count
- WHERE ((activity_state_count.state)::text = ANY ((ARRAY['completed'::character varying, 'reviewed'::character varying])::text[]))
+ WHERE ((activity_state_count.state)::text = ANY (ARRAY[('completed'::character varying)::text, ('reviewed'::character varying)::text]))
GROUP BY activity_state_count.membership_id
)
SELECT at.membership_id,
@@ -676,7 +676,7 @@ CREATE VIEW completion_rate_by_variety AS
activity_state_count_by_variety.variety,
sum(activity_state_count_by_variety.count) AS completed
FROM activity_state_count_by_variety
- WHERE ((activity_state_count_by_variety.state)::text = ANY ((ARRAY['completed'::character varying, 'reviewed'::character varying])::text[]))
+ WHERE ((activity_state_count_by_variety.state)::text = ANY (ARRAY[('completed'::character varying)::text, ('reviewed'::character varying)::text]))
GROUP BY activity_state_count_by_variety.membership_id, activity_state_count_by_variety.variety
)
SELECT atv.membership_id,
@@ -712,7 +712,7 @@ CREATE VIEW completion_rate_by_variety_in_last_two_weeks AS
activity_state_count_by_variety.variety,
sum(activity_state_count_by_variety.count) AS completed
FROM activity_state_count_by_variety
- WHERE ((activity_state_count_by_variety.state)::text = ANY ((ARRAY['completed'::character varying, 'reviewed'::character varying])::text[]))
+ WHERE ((activity_state_count_by_variety.state)::text = ANY (ARRAY[('completed'::character varying)::text, ('reviewed'::character varying)::text]))
GROUP BY activity_state_count_by_variety.membership_id, activity_state_count_by_variety.variety
)
SELECT atv.membership_id,
@@ -788,7 +788,7 @@ CREATE VIEW completion_rate_in_last_two_weeks AS
SELECT activity_state_count.membership_id,
sum(activity_state_count.count) AS completed
FROM activity_state_count
- WHERE ((activity_state_count.state)::text = ANY ((ARRAY['completed'::character varying, 'reviewed'::character varying])::text[]))
+ WHERE ((activity_state_count.state)::text = ANY (ARRAY[('completed'::character varying)::text, ('reviewed'::character varying)::text]))
GROUP BY activity_state_count.membership_id
)
SELECT at.membership_id,
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment