数据库·存储过程··sql

create function pr_create_goods_map()
  returns integer
language plpgsql
as $$
declare
   recd RECORD;
   lvar_goods_alias_id varchar(12);
   lvar_goods_id varchar(12);
   outint_cnt Integer;
begin
    outint_cnt = 0;
    create temporary table "goods_map" as
    
   

    for recd in (select * from goods_map order by goods_code) loop
        outint_cnt = outint_cnt + 1;

        
    end loop;
    drop table goods_map;
  return outint_cnt;
end;
$$;