2 391
edições
m (→tentativa 3: fez o esperado) |
m (→tentativa 3: add p_blocksize) |
||
Linha 188: | Linha 188: | ||
p_contry_base integer, | p_contry_base integer, | ||
p_id_bitlen integer, -- ex. 37 | p_id_bitlen integer, -- ex. 37 | ||
p_lev0 numeric default 2.5 | p_lev0 numeric default 2.5, | ||
p_blocksize int default 100 | |||
) RETURNS text LANGUAGE plpgsql AS $f$ | ) RETURNS text LANGUAGE plpgsql AS $f$ | ||
DECLARE | DECLARE | ||
Linha 213: | Linha 214: | ||
select cod_b16h, row_number() over() ord | select cod_b16h, row_number() over() ord | ||
from grid_br2.poc_caruaru_vw01logistic | from grid_br2.poc_caruaru_vw01logistic | ||
where length(gid_vbit)= | where length(gid_vbit)=$3 | ||
) t1 | ) t1 | ||
GROUP BY ord/ | GROUP BY ord/$5 | ||
) t2; | ) t2; | ||
-- $3 = grid_generate_all_levels_logistic2.p_id_bitlen | |||
FOREACH cover_frag IN ARRAY oid_list LOOP | FOREACH cover_frag IN ARRAY oid_list LOOP | ||
s:=''; | s:=''; | ||
Linha 232: | Linha 233: | ||
$f$; | $f$; | ||
SELECT volat_file_write( | SELECT volat_file_write( -- com 37 e 500 dá 5Mb | ||
'/tmp/inserts_logistic2.sql' | '/tmp/inserts_logistic2.sql' | ||
, osmc.grid_generate_all_levels_logistic2( 2.5, 'BR', 27, 18 ) | , osmc.grid_generate_all_levels_logistic2( 2.5, 'BR', 27, 18, 100 ) | ||
); | ); | ||
</syntaxhighlight> | </syntaxhighlight> |
edições