Falta incluir intervalo de CEP de 20 cidades about city-codes HOT 2 CLOSED

create table newcep(ibge text, lexlabel text, ceps text);
insert into newcep VALUES
 ('2928505','santa.teresinha','44590-000 a 44599-999')
,('5203500','bom.jesus.goias','75570-000 a 75579-999')
,('2104552','governador.edison.lobao','65928-000 a 65928-999')
 ('2110278','santo.amaro.maranhao','65195-000 a 65199-999')
,('2111763','senador.la.rocque','65935-000 a 65935-499')
,('3108909','brazopolis','37530-000 a 37539-999')
,('3122900','dona.eusebia','36784-000 a 36787-999')
,('1506500','santa.izabel.para','68790-000 a 68794-999')
,('2513968','sao.domingos','58853-000 a 58854-999')
,('2606903','iguaracy','56840-000 a 56849-999')
,('3303807','paraty','23970-000 a 23999-999')
,('3305901','trajano.moraes','28750-000 a 28769-999')
,('2401206','ares','59170-000 a 59172-999')
,('2405306','boa.saude','59260-000 a 59269-999')
,('2401305','campo.grande','59680-000 a 59684-999')
,('1100098','espigao.d.oeste','76974-000 a 76975-999')
,('4317103','sant.ana.livramento','97570-001 a 97589-999')
,('2802601','gracho.cardoso','49860-000 a 49869-999')
,('3550001','sao.luis.paraitinga','12140-000 a 12169-999')
,('1720499','sao.valerio.natividade','77390-000 a 77394-999');

-- test -- select c.name, concat('[',replace(n.ceps,' a ',' '),']') as cep_range from citybr c inner join newcep n ON n.ibge=c."idIBGE" AND c."lexLabel"=n.lexlabel;

UPDATE citybr 
SET "postalCode_ranges" = concat('[',replace(t.ceps,' a ',' '),']')  
FROM newcep t
WHERE citybr."postalCode_ranges" IS NULL AND t.ibge=citybr."idIBGE" ;