CREATE OR REPLACE FUNCTION public.documents_insert_trigger (
)
RETURNS trigger AS
$body$
BEGIN
 -- raise exception 'XAXAXAXA';
  
    IF ( NEW.dt_registration >= DATE '2006-01-01' AND
         NEW.dt_registration < DATE '2007-01-01' ) THEN
        INSERT INTO documents_2006 VALUES (NEW.*);
    ELSIF ( NEW.dt_registration >= DATE '2007-01-01' AND
            NEW.dt_registration < DATE '2008-01-01' ) THEN
        INSERT INTO documents_2007 VALUES (NEW.*);
    ELSIF ( NEW.dt_registration >= DATE '2008-01-01' AND
            NEW.dt_registration < DATE '2009-01-01' ) THEN
        INSERT INTO documents_2008 VALUES (NEW.*);
    ELSIF ( NEW.dt_registration >= DATE '2009-01-01' AND
            NEW.dt_registration < DATE '2010-01-01' ) THEN
        INSERT INTO documents_2009 VALUES (NEW.*);
    ELSIF ( NEW.dt_registration >= DATE '2010-01-01' AND
            NEW.dt_registration < DATE '2011-01-01' ) THEN
        INSERT INTO documents_2010 VALUES (NEW.*);
    ELSIF ( NEW.dt_registration >= DATE '2011-01-01' AND
            NEW.dt_registration < DATE '2012-01-01' ) THEN
        INSERT INTO documents_2011 VALUES (NEW.*);
    ELSIF ( NEW.dt_registration >= DATE '2012-01-01' AND
            NEW.dt_registration < DATE '2013-01-01' ) THEN
        INSERT INTO documents_2012 VALUES (NEW.*);
    ELSIF ( NEW.dt_registration >= DATE '2013-01-01' AND
            NEW.dt_registration < DATE '2014-01-01' ) THEN
        INSERT INTO documents_2013 VALUES (NEW.*);
    ELSIF ( NEW.dt_registration >= DATE '2014-01-01' AND
            NEW.dt_registration < DATE '2015-01-01' ) THEN
        INSERT INTO documents_2014 VALUES (NEW.*);
    ELSIF ( NEW.dt_registration >= DATE '2015-01-01' AND
            NEW.dt_registration < DATE '2016-01-01' ) THEN
        INSERT INTO documents_2015 VALUES (NEW.*);
    ELSIF ( NEW.dt_registration >= DATE '2016-01-01' AND
            NEW.dt_registration < DATE '2017-01-01' ) THEN
        INSERT INTO documents_2016 VALUES (NEW.*);
    ELSIF ( NEW.dt_registration >= DATE '2017-01-01' AND
            NEW.dt_registration < DATE '2018-01-01' ) THEN
        INSERT INTO documents_2017 VALUES (NEW.*);
    ELSIF ( NEW.dt_registration >= DATE '2018-01-01' OR
            NEW.dt_registration < DATE '2006-01-01' ) THEN
        INSERT INTO documents_musor VALUES (NEW.*);
    ELSE
        RAISE EXCEPTION 'Date out of range.  Fix the documents_insert_trigger() function!';
    END IF;
    RETURN NULL;
END;
$body$
LANGUAGE 'plpgsql'
VOLATILE
CALLED ON NULL INPUT
SECURITY INVOKER
COST 100;

CREATE OR REPLACE FUNCTION public.test_update (
)
RETURNS trigger AS
$body$
BEGIN
raise exception '44444444444444444444';
  
  IF (NEW.dt_registration is distinct from OLD.dt_registration)	THEN 
    INSERT INTO documents VALUES (NEW.*);
    RETURN NULL;    
  ELSE
    --INSERT INTO documents VALUES (OLD.*);
    RETURN new;
  END IF;
  
END;
$body$
LANGUAGE 'plpgsql'
VOLATILE
CALLED ON NULL INPUT
SECURITY INVOKER
COST 100;

BEGIN
	BEGIN
                EXECUTE 'INSERT INTO documents_'||to_char(NEW.DT_REGISTRATION, 'YYYY')||' SELECT $1.*' USING NEW;
            EXCEPTION
            WHEN undefined_table THEN
                RETURN NEW;
            END;
            RETURN NULL;
END;

DECLARE
year_extr bigint;
BEGIN
	SELECT date_part('year', NEW.DT_REGISTRATION) INTO year_extr;
	IF year_extr<2006 and year_extr>2017 THEN
    INSERT INTO documents_musor VALUES (NEW.*);
    ELSE
    EXECUTE 'INSERT INTO documents_'||to_char(NEW.DT_REGISTRATION, 'YYYY')||' SELECT $1.*' USING NEW;
    END IF;
    RETURN NEW;
END;