From 740a963a63f86d0891270117612904f0ba8581ee Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Wed, 22 May 2013 22:05:53 -0400 Subject: [PATCH] Various typos on Q4. --- tables/games.tab | 2 +- triggers/team_game_stats_ins_trg.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/tables/games.tab b/tables/games.tab index 3ff3a4d..b90b0ef 100755 --- a/tables/games.tab +++ b/tables/games.tab @@ -117,7 +117,7 @@ CREATE INDEX games_2014Q3_ix001 on games_2014Q3(create_dt); ALTER TABLE xonstat.games_2014Q3 OWNER TO xonstat; CREATE TABLE xonstat.games_2014Q4 ( - CHECK ( create_dt >= DATE '2014-10-01' AND create_dt < DATE '2014-01-01' ) + CHECK ( create_dt >= DATE '2014-10-01' AND create_dt < DATE '2015-01-01' ) ) INHERITS (games); CREATE INDEX games_2014Q4_ix001 on games_2014Q4(create_dt); ALTER TABLE xonstat.games_2014Q4 OWNER TO xonstat; diff --git a/triggers/team_game_stats_ins_trg.sql b/triggers/team_game_stats_ins_trg.sql index a4b79e6..b968fd5 100644 --- a/triggers/team_game_stats_ins_trg.sql +++ b/triggers/team_game_stats_ins_trg.sql @@ -16,7 +16,7 @@ BEGIN INSERT INTO team_game_stats_2014Q2 VALUES (NEW.*); ELSIF (NEW.create_dt >= DATE '2014-07-01' AND NEW.create_dt < DATE '2014-10-01') THEN INSERT INTO team_game_stats_2014Q3 VALUES (NEW.*); - ELSIF (NEW.create_dt >= DATE '2014-10-01' AND NEW.create_dt < DATE '2015-10-01') THEN + ELSIF (NEW.create_dt >= DATE '2014-10-01' AND NEW.create_dt < DATE '2015-01-01') THEN INSERT INTO team_game_stats_2014Q4 VALUES (NEW.*); ELSE -- 2.39.2