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;
$$;