Postgresql 存储过程(plpgsql)两层for循环的操作

CREATE [ OR REPLACE ] FUNCTION

   name ( [ [argmode] [argname]argtype[ { DEFAULT | = }default_expr] [, ...] ] )

     [ RETURNSrettype

      | RETURNS TABLE (column_namecolumn_type[, ...] ) ]

   { LANGUAGElang_name

     | WINDOW

| IMMUTABLE | STABLE | VOLATILE

     | CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT

     | [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER

     | COSTexecution_cost

     | ROWSresult_rows

     | SETconfiguration_parameter{ TOvalue| =value| FROM CURRENT }

     | AS 'definition'

     | AS 'obj_file' , 'link_symbol'

   } ...

     [ WITH (attribute[, ...] ) ]

————————————————

CREATE OR REPLACE FUNCTION "xue" . "insert_into_table" ()

  RETURNS "pg_catalog" . "void" AS $BODY$

DECLARE tmp VARCHAR (1024);

DECLARE n integer ;

DECLARE i integer ;

DECLARE inst_seq_no CURSOR FOR

   SELECT inst_seq_no FROM t where no in (

   '111' , '22' , '223' , '33' , '4358' ,

    '233' , '449' , '315' , '35335' );

BEGIN

   RAISE NOTICE '------------start----------' ;

   i := 30;

   FOR stmt IN no LOOP

     n := 30;

     FOR n IN n..i LOOP   

       insert into test2 ( NO ,

       test_NO, TIME ,USER_NO,SEQ_NO,

       NAME ,USER_NO1,USER_NAME,CODE,USER_NO2,OPROR_NAME,

       REVIEW_TIME, DESC ,

       VAL1,VAL2, DATE ,UPD_TIME,DEL_FLAG) values

       (nextval( 'seq_test2' ),n, '20190910' ,n,stmt.seq_no,n,n,n,n,n,n, '20190910' , '01' , '' ,n,n, '20190910' ,

       '20190909' , '0' );

       END LOOP;

        n = n+30;

       i = i+30;

   END LOOP;

   RAISE NOTICE '-----------finished---------' ;

END ;

$BODY$

  LANGUAGE plpgsql VOLATILE

  COST 100`

PERFORM query;

PERFORM create_mv( 'cs_session_page_requests_mv' , my_query);