2 391
edições
m (→tentativa 4) |
m (→tentativa 3: rev) |
||
Linha 196: | Linha 196: | ||
lev numeric; | lev numeric; | ||
s text :=''; | s text :=''; | ||
ret text :=''; | |||
gg text :='geom4326'; | gg text :='geom4326'; | ||
BEGIN | BEGIN | ||
Linha 206: | Linha 207: | ||
) t | ) t | ||
$$; | $$; | ||
RAISE NOTICE 'entrei...'; | -- RAISE NOTICE 'entrei...'; | ||
select array_agg(x::text) INTO oid_list | select array_agg(x::text) INTO oid_list | ||
FROM ( | FROM ( | ||
Linha 217: | Linha 218: | ||
GROUP BY ord/100 | GROUP BY ord/100 | ||
) t2; | ) t2; | ||
FOREACH cover_frag IN ARRAY oid_list LOOP | FOREACH cover_frag IN ARRAY oid_list LOOP | ||
s:=''; | |||
RAISE NOTICE 'Loop cover_frag... %s', cover_frag; | -- RAISE NOTICE 'Loop cover_frag... %s', cover_frag; | ||
FOR lev IN (select x from generate_series(p_lev0, p_lev_max, 2.5) t(x)) LOOP | FOR lev IN (select x from generate_series(p_lev0, p_lev_max, 2.5) t(x)) LOOP | ||
IF lev>p_lev0 THEN s := s || E'\n UNION ALL \n'; END IF; | IF lev>p_lev0 THEN s := s || E'\n UNION ALL \n'; END IF; | ||
Linha 225: | Linha 227: | ||
END LOOP; -- lev | END LOOP; -- lev | ||
s := s|| E'\n ORDER BY 1'; | s := s|| E'\n ORDER BY 1'; | ||
ret := ret || E'INSERT INTO grid_br2.tmp_cells \n' || s || E';\n COMMIT; \n\n\n'; | |||
RAISE NOTICE 'RODANDO %', s | --RAISE NOTICE 'RODANDO %', s; | ||
END LOOP; -- cover_frag | END LOOP; -- cover_frag | ||
RAISE NOTICE 'sai...'; | --RAISE NOTICE 'sai...'; | ||
RETURN | RETURN ret; | ||
END; | END; | ||
$f$; | $f$; |
edições