maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ecmevent_parameter_part_trig_func()
Parameters
Name
Type
Mode
Definition
BEGIN IF TG_OP = 'INSERT' THEN IF NEW.receivedate >= '2016-05-17 00:00:00+00' AND NEW.receivedate < '2016-05-18 00:00:00+00' THEN INSERT INTO public.ecmevent_parameter_p2016_05_17 VALUES (NEW.*); ELSIF NEW.receivedate >= '2016-05-16 00:00:00+00' AND NEW.receivedate < '2016-05-17 00:00:00+00' THEN INSERT INTO public.ecmevent_parameter_p2016_05_16 VALUES (NEW.*); ELSIF NEW.receivedate >= '2016-05-18 00:00:00+00' AND NEW.receivedate < '2016-05-19 00:00:00+00' THEN INSERT INTO public.ecmevent_parameter_p2016_05_18 VALUES (NEW.*); ELSIF NEW.receivedate >= '2016-05-15 00:00:00+00' AND NEW.receivedate < '2016-05-16 00:00:00+00' THEN INSERT INTO public.ecmevent_parameter_p2016_05_15 VALUES (NEW.*); ELSIF NEW.receivedate >= '2016-05-19 00:00:00+00' AND NEW.receivedate < '2016-05-20 00:00:00+00' THEN INSERT INTO public.ecmevent_parameter_p2016_05_19 VALUES (NEW.*); ELSIF NEW.receivedate >= '2016-05-14 00:00:00+00' AND NEW.receivedate < '2016-05-15 00:00:00+00' THEN INSERT INTO public.ecmevent_parameter_p2016_05_14 VALUES (NEW.*); ELSIF NEW.receivedate >= '2016-05-20 00:00:00+00' AND NEW.receivedate < '2016-05-21 00:00:00+00' THEN INSERT INTO public.ecmevent_parameter_p2016_05_20 VALUES (NEW.*); ELSIF NEW.receivedate >= '2016-05-13 00:00:00+00' AND NEW.receivedate < '2016-05-14 00:00:00+00' THEN INSERT INTO public.ecmevent_parameter_p2016_05_13 VALUES (NEW.*); ELSIF NEW.receivedate >= '2016-05-21 00:00:00+00' AND NEW.receivedate < '2016-05-22 00:00:00+00' THEN INSERT INTO public.ecmevent_parameter_p2016_05_21 VALUES (NEW.*); ELSE RETURN NEW; END IF; END IF; RETURN NULL; END