2 402
edições
m (→tentativa 3: parametrizando) |
|||
Linha 215: | Linha 215: | ||
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)=grid_generate_all_levels_logistic2.p_id_bitlen | ||
) t1 | ) t1 | ||
GROUP BY ord/ | GROUP BY ord/grid_generate_all_levels_logistic2.p_blocksize | ||
) t2; | ) t2; | ||
-- $3 = grid_generate_all_levels_logistic2.p_id_bitlen | -- $3 = grid_generate_all_levels_logistic2.p_id_bitlen | ||
Linha 236: | Linha 236: | ||
SELECT volat_file_write( -- com 37 e 500 dá 5Mb | 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', 18, 27, 2.5, | , osmc.grid_generate_all_levels_logistic2( 2.5, 'BR', 18, 27, 2.5, 300 ) | ||
); | ); | ||
-- deu certo! | -- deu certo! |
edições