maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
event_p2016w18_part_trig_func()
Parameters
Name
Type
Mode
Definition
BEGIN IF TG_OP = 'INSERT' THEN IF NEW.senddate >= '2016-05-01 00:00:00+00' AND NEW.senddate < '2016-05-02 00:00:00+00' THEN INSERT INTO public.event_p2016w18_p2016_05_01 VALUES (NEW.*); ELSIF NEW.senddate >= '2016-04-30 00:00:00+00' AND NEW.senddate < '2016-05-01 00:00:00+00' THEN INSERT INTO public.event_p2016w18_p2016_04_30 VALUES (NEW.*); ELSIF NEW.senddate >= '2016-05-02 00:00:00+00' AND NEW.senddate < '2016-05-03 00:00:00+00' THEN INSERT INTO public.event_p2016w18_p2016_05_02 VALUES (NEW.*); ELSIF NEW.senddate >= '2016-04-29 00:00:00+00' AND NEW.senddate < '2016-04-30 00:00:00+00' THEN INSERT INTO public.event_p2016w18_p2016_04_29 VALUES (NEW.*); ELSIF NEW.senddate >= '2016-05-03 00:00:00+00' AND NEW.senddate < '2016-05-04 00:00:00+00' THEN INSERT INTO public.event_p2016w18_p2016_05_03 VALUES (NEW.*); ELSIF NEW.senddate >= '2016-04-28 00:00:00+00' AND NEW.senddate < '2016-04-29 00:00:00+00' THEN INSERT INTO public.event_p2016w18_p2016_04_28 VALUES (NEW.*); ELSIF NEW.senddate >= '2016-05-04 00:00:00+00' AND NEW.senddate < '2016-05-05 00:00:00+00' THEN INSERT INTO public.event_p2016w18_p2016_05_04 VALUES (NEW.*); ELSIF NEW.senddate >= '2016-04-27 00:00:00+00' AND NEW.senddate < '2016-04-28 00:00:00+00' THEN INSERT INTO public.event_p2016w18_p2016_04_27 VALUES (NEW.*); ELSIF NEW.senddate >= '2016-05-05 00:00:00+00' AND NEW.senddate < '2016-05-06 00:00:00+00' THEN INSERT INTO public.event_p2016w18_p2016_05_05 VALUES (NEW.*); ELSE RETURN NEW; END IF; END IF; RETURN NULL; END