Re: [Gnumed-devel] Updating dem listings for Brazil

[Busser, Jim]

Better:

UPDATE dem.state
SET code = 'AP', name = 'Amapá' WHERE name = 'Amapa' AND country = 'BR';

UPDATE dem.state
SET code = 'AM' WHERE name = 'Amazonas'  AND country = 'BR';

UPDATE dem.state
SET name = 'Ceará' WHERE name = 'Ceara'  AND country = 'BR';

UPDATE dem.state
SET name = 'Espírito Santo' WHERE name = 'Espirito Santo'  AND country = 'BR';

UPDATE dem.state
SET name = 'Goiás' WHERE name = 'Goias'  AND country = 'BR';

UPDATE dem.state
SET name = 'Maranhão' WHERE name = 'Maranhao'  AND country = 'BR';

UPDATE dem.state
SET code = 'MT' WHERE name = 'Mato Grosso'  AND country = 'BR';

UPDATE dem.state
SET code = 'MG' WHERE name = 'Minas Gerais'  AND country = 'BR';

UPDATE dem.state
SET name = 'Pará' WHERE name = 'Para'  AND country = 'BR';

UPDATE dem.state
SET code = 'PB', name = 'Paraíba' WHERE name = 'Paraiba'  AND country = 'BR';

UPDATE dem.state
SET name = 'Piauí' WHERE name = 'Piaui'  AND country = 'BR';

UPDATE dem.state
SET code = 'PR', name = 'Paraná' WHERE name = 'Parana'  AND country = 'BR';

UPDATE dem.state
SET name = 'Rondônia' WHERE name = 'Rondonia'  AND country = 'BR';

UPDATE dem.state
SET name = 'São Paulo' WHERE name = 'Sao Paulo'  AND country = 'BR';

-- Jim