1 CREATE OR REPLACE FUNCTION player_weapon_stats_ins()
4 IF (NEW.create_dt >= DATE '2013-04-01' AND NEW.create_dt < DATE '2013-07-01') THEN
5 INSERT INTO player_weapon_stats_2013Q2 VALUES (NEW.*);
6 ELSIF (NEW.create_dt >= DATE '2013-07-01' AND NEW.create_dt < DATE '2013-10-01') THEN
7 INSERT INTO player_weapon_stats_2013Q3 VALUES (NEW.*);
8 ELSIF (NEW.create_dt >= DATE '2013-10-01' AND NEW.create_dt < DATE '2014-01-01') THEN
9 INSERT INTO player_weapon_stats_2013Q4 VALUES (NEW.*);
12 ELSIF (NEW.create_dt >= DATE '2014-01-01' AND NEW.create_dt < DATE '2014-04-01') THEN
13 INSERT INTO player_weapon_stats_2014Q1 VALUES (NEW.*);
14 ELSIF (NEW.create_dt >= DATE '2014-04-01' AND NEW.create_dt < DATE '2014-07-01') THEN
15 INSERT INTO player_weapon_stats_2014Q2 VALUES (NEW.*);
16 ELSIF (NEW.create_dt >= DATE '2014-07-01' AND NEW.create_dt < DATE '2014-10-01') THEN
17 INSERT INTO player_weapon_stats_2014Q3 VALUES (NEW.*);
18 ELSIF (NEW.create_dt >= DATE '2014-10-01' AND NEW.create_dt < DATE '2015-01-01') THEN
19 INSERT INTO player_weapon_stats_2014Q4 VALUES (NEW.*);
22 RAISE EXCEPTION 'Date out of range. Fix the player_weapon_stats_ins() trigger!';
29 DROP TRIGGER IF EXISTS player_weapon_stats_ins_trg ON xonstat.player_weapon_stats;
30 CREATE TRIGGER player_weapon_stats_ins_trg
31 BEFORE INSERT on xonstat.player_weapon_stats
32 FOR EACH ROW EXECUTE PROCEDURE player_weapon_stats_ins();