beautifull sql

with example

with temp as (select d_codigo 
              from (select d_codigo,d_estado, length(d_codigo) 
                     from colonia_tmp
                     group by d_codigo,d_estado 
                     having length(d_codigo) = 4) newcode)
    update colonia_tmp set d_codigo= '0' || d_codigo where d_codigo in  (select d_codigo from temp);