Postgresql implementation method by hour table (including triggers)

CREATE OR REPLACE FUNCTION auto_insert_into_tbl_partition()
 RETURNS trigger AS
$BODY$
DECLARE
  time_column_name   text ;      -- The name of the time field used for partitioning in the parent table[Must be initialized first!!]
  curMM     varchar(16);    -- 'YYYYMM'String,Used as the suffix of partitioned subtables
  isExist     boolean;    -- Partition subtable,Whether it already exists
  strSQL     text;
  
BEGIN
  -- Before calling,Must be initialized first(Time field name):time_column_name [Get it directly from the call parameters!!]
  time_column_name := TG_ARGV[0];
  
  -- Determine the corresponding partition table Whether it already exists?
  EXECUTE 'SELECT $1.'||time_column_name INTO strSQL USING NEW;
  curMM := to_char( strSQL::timestamp , 'YYYYMMDDHH' );
  select count(1) INTO isExist from pg_class where relname = ('t_audit_'||curMM);
 
  -- If it does not exist, Before insertion Create a subpartition first
  IF ( isExist = false ) THEN 
    -- Create a subpartition table
    strSQL := 'CREATE TABLE IF NOT EXISTS t_audit_'||curMM||'() INHERITS (t_audit);' ; 
    EXECUTE strSQL;
    -- Create an index
    strSQL := 'CREATE INDEX t_audit_'||curMM||'_INDEX_'||time_column_name||' ON t_audit_'||curMM||' ('||time_column_name||');' ;
    EXECUTE strSQL;
  END IF;
 
  -- Insert data into subpartition!
  strSQL := 'INSERT INTO t_audit_'||curMM||' SELECT $1.*' ;
  EXECUTE strSQL USING NEW;
  RETURN NULL; 
END
$BODY$
 LANGUAGE plpgsql;

CREATE TRIGGER insert_tbl_partition_trigger
 BEFORE INSERT
 ON t_audit
 FOR EACH ROW
 EXECUTE PROCEDURE auto_insert_into_tbl_partition('time');

CREATE OR REPLACE FUNCTION "public"."trigger_day_aqi"()
 RETURNS "pg_catalog"."trigger" AS $BODY$
BEGIN
  --Daily average table，Noo3,Hour Value Table，Noo3_8h
   NEW.so2iaqi=DAY_SO2_AQI(NEW.so2);
     NEW.no2iaqi=DAY_NO2_AQI(NEW.no2);
     =DAY_CO_AQI();
     NEW.o3_8hiaqi=O3_8_AQI(NEW.o3_8h);
     NEW.pm10iaqi=PM10_AQI(NEW.pm10);
     NEW.pm25iaqi=PM25_AQI(NEW.pm25);
     =;
     ='CO';
    IF <NEW.no2iaqi  then  =NEW.no2iaqi;  ='NO2';  end if;
    IF <NEW.so2iaqi  then  =NEW.so2iaqi;  ='SO2';  end if;
    IF <NEW.o3_8hiaqi then  =NEW.o3_8hiaqi;  ='O3_8H'; end if;
    IF <NEW.pm10iaqi then  =NEW.pm10iaqi;  ='PM10';  end if;
    IF <NEW.pm25iaqi then  =NEW.pm25iaqi;  ='PM2.5'; end if; 
    IF <=50      then  ='-';   end if;
     =getRank();
  RETURN NEW;
END;
$BODY$
 LANGUAGE plpgsql VOLATILE
 COST 100

CREATE TRIGGER gk_site_day_insert BEFORE INSERT ON gk_site_day
  FOR EACH ROW EXECUTE PROCEDURE trigger_day_aqi();