2 402
edições
m (→tentativa 3: add p_blocksize) |
|||
Linha 185: | Linha 185: | ||
; | ; | ||
CREATE or replace FUNCTION osmc.grid_generate_all_levels_logistic2( | CREATE or replace FUNCTION osmc.grid_generate_all_levels_logistic2( | ||
p_lev_max numeric, p_contry text, | p_lev_max numeric, | ||
p_contry text, | |||
p_contry_base integer, | p_contry_base integer, | ||
p_id_bitlen integer, -- ex. 37 | p_id_bitlen integer, -- ex. 37 | ||
Linha 214: | 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)=27 | ||
) t1 | ) t1 | ||
GROUP BY ord/ | GROUP BY ord/100 | ||
) t2; | ) t2; | ||
-- $3 = grid_generate_all_levels_logistic2.p_id_bitlen | -- $3 = grid_generate_all_levels_logistic2.p_id_bitlen | ||
Linha 235: | 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', 27, | , osmc.grid_generate_all_levels_logistic2( 2.5, 'BR', 18, 27, 2.5, 100 ) | ||
); | ); | ||
-- deu certo! | |||
</syntaxhighlight> | </syntaxhighlight> | ||
edições