Le portail francophone de la géomatique

DROP SEQUENCE IF EXISTS gracethd_metis.t_noeud_incrementation_nd_code;
CREATE SEQUENCE gracethd_metis.t_noeud_incrementation_nd_code
  INCREMENT 1
  MINVALUE 00000
  MAXVALUE 99999
  START 1
  CACHE 1;
ALTER TABLE gracethd_metis.t_noeud OWNER TO postgres;

WITH vue_metier AS    
(    SELECT
          concat(digt_6, digt_7, digt_8, digt_9) as sro
        ,'SF' as nb_type
    FROM rbal.bal_hsn_point_2154 a
    LEFT JOIN psd_orange.ref_code_zasro b ON a.nom_sro=b.code_sro_definitif)
    SELECT 
    concat('ND700',sro , to_char(nextval('gracethd.t_noeud_incrementation_nd_code'), 'FM00000')) as nd_code,
    sro, 
    nb_type,    
    FROM vue_metier

create or replace function fetcher (n integer)
returns void as $$
declare
sro record;
begin
for sro in 
select cd_sro 
from 
(with code_sro as (select concat(digt_6, digt_7, digt_8, digt_9) as cd_sro 
from psd_orange.ref_code_zasro)
select cd_sro from code_sro)a
limit n
loop
raise notice '%', sro.cd_sro;
end loop;
end;
$$language plpgsql;