maya.public

Parameters

Name	Type	Mode

Definition

BEGIN 
        IF TG_OP = 'INSERT' THEN 
            IF NEW.senddate >= '2016-08-23 00:00:00+00' AND NEW.senddate < '2016-08-24 00:00:00+00' THEN 
                INSERT INTO public.event_p2016_08_23 VALUES (NEW.*); 
            ELSIF NEW.senddate >= '2016-08-22 00:00:00+00' AND NEW.senddate < '2016-08-23 00:00:00+00' THEN 
                INSERT INTO public.event_p2016_08_22 VALUES (NEW.*); 
            ELSIF NEW.senddate >= '2016-08-24 00:00:00+00' AND NEW.senddate < '2016-08-25 00:00:00+00' THEN 
                INSERT INTO public.event_p2016_08_24 VALUES (NEW.*);
            ELSIF NEW.senddate >= '2016-08-21 00:00:00+00' AND NEW.senddate < '2016-08-22 00:00:00+00' THEN 
                INSERT INTO public.event_p2016_08_21 VALUES (NEW.*); 
            ELSIF NEW.senddate >= '2016-08-25 00:00:00+00' AND NEW.senddate < '2016-08-26 00:00:00+00' THEN 
                INSERT INTO public.event_p2016_08_25 VALUES (NEW.*);
            ELSIF NEW.senddate >= '2016-08-20 00:00:00+00' AND NEW.senddate < '2016-08-21 00:00:00+00' THEN 
                INSERT INTO public.event_p2016_08_20 VALUES (NEW.*); 
            ELSIF NEW.senddate >= '2016-08-26 00:00:00+00' AND NEW.senddate < '2016-08-27 00:00:00+00' THEN 
                INSERT INTO public.event_p2016_08_26 VALUES (NEW.*);
            ELSIF NEW.senddate >= '2016-08-19 00:00:00+00' AND NEW.senddate < '2016-08-20 00:00:00+00' THEN 
                INSERT INTO public.event_p2016_08_19 VALUES (NEW.*); 
            ELSIF NEW.senddate >= '2016-08-27 00:00:00+00' AND NEW.senddate < '2016-08-28 00:00:00+00' THEN 
                INSERT INTO public.event_p2016_08_27 VALUES (NEW.*);
            ELSIF NEW.senddate >= '2016-08-18 00:00:00+00' AND NEW.senddate < '2016-08-19 00:00:00+00' THEN 
                INSERT INTO public.event_p2016_08_18 VALUES (NEW.*); 
            ELSIF NEW.senddate >= '2016-08-28 00:00:00+00' AND NEW.senddate < '2016-08-29 00:00:00+00' THEN 
                INSERT INTO public.event_p2016_08_28 VALUES (NEW.*);
            ELSIF NEW.senddate >= '2016-08-17 00:00:00+00' AND NEW.senddate < '2016-08-18 00:00:00+00' THEN 
                INSERT INTO public.event_p2016_08_17 VALUES (NEW.*); 
            ELSIF NEW.senddate >= '2016-08-29 00:00:00+00' AND NEW.senddate < '2016-08-30 00:00:00+00' THEN 
                INSERT INTO public.event_p2016_08_29 VALUES (NEW.*);
            ELSIF NEW.senddate >= '2016-08-16 00:00:00+00' AND NEW.senddate < '2016-08-17 00:00:00+00' THEN 
                INSERT INTO public.event_p2016_08_16 VALUES (NEW.*); 
            ELSIF NEW.senddate >= '2016-08-30 00:00:00+00' AND NEW.senddate < '2016-08-31 00:00:00+00' THEN 
                INSERT INTO public.event_p2016_08_30 VALUES (NEW.*); 
            ELSE 
                RETURN NEW; 
            END IF; 
        END IF; 
        RETURN NULL; 
        END

event_part_trig_func()

Parameters

Definition