ALTER TABLE public.pet_agenda ADD COLUMN endereco character varying(1);


UPDATE pet_agenda SET endereco = (SELECT MIN(sequencia) 
                                    FROM cli_endereco 
                                   WHERE cliente = (SELECT cliente 
													  FROM pet_animal 
													 WHERE codigo = pet_agenda.animal)
                                     AND tipo_endereco = 'E') 
 WHERE endereco IS NULL;


 ALTER TABLE public.pet_agenda ALTER COLUMN endereco SET NOT NULL;