From 2d7fcc7e05d52dc7a17281bc84f1d3d0d58532d1 Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Tue, 1 Oct 2013 20:44:38 -0400 Subject: [PATCH] Fix date range for q4 partition. --- triggers/team_game_stats_ins_trg.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/triggers/team_game_stats_ins_trg.sql b/triggers/team_game_stats_ins_trg.sql index b968fd5..6a0974c 100644 --- a/triggers/team_game_stats_ins_trg.sql +++ b/triggers/team_game_stats_ins_trg.sql @@ -6,7 +6,7 @@ BEGIN INSERT INTO team_game_stats_2013Q2 VALUES (NEW.*); ELSIF (NEW.create_dt >= DATE '2013-07-01' AND NEW.create_dt < DATE '2013-10-01') THEN INSERT INTO team_game_stats_2013Q3 VALUES (NEW.*); - ELSIF (NEW.create_dt >= DATE '2013-10-01' AND NEW.create_dt < DATE '2013-01-01') THEN + ELSIF (NEW.create_dt >= DATE '2013-10-01' AND NEW.create_dt < DATE '2014-01-01') THEN INSERT INTO team_game_stats_2013Q4 VALUES (NEW.*); -- 2014 -- 2.39.2