1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
|
create procedure fnc_113819()
language plpgsql
as $$
declare count_plan_adressage integer;
declare r_var record;
declare adresse_tetra_var varchar;
declare id_var numeric;
begin
select count(*) from plan_adressage into count_plan_adressage where adresse_radio_tetra like '0%';
if count_plan_adressage > 0 then
for r_var in select * from plan_adressage where adresse_radio_tetra like '0%' loop
adresse_tetra_var = r_var.adresse_radio_tetra;
id_var = r_var.id;
update plan_adressage set adresse_radio_tetra=substring(adresse_tetra_var from 2) where id=id_var;
end loop;
call fnc_113819();
end if;
end;
$$;
call fnc_113819();
drop procedure fnc_113819(); |