SELECT country_iso_code,subdivision_iso_name,city_name INTO v_country_iso_code, v_subdivision_name v_city_name FROM city_locations WHERE geoname_id = v_geoname_id;
- IF (v_country_iso_code != '') THEN
+ IF v_country_iso_code != '' THEN
SELECT id INTO v_country_id FROM core_geoip_country WHERE code = v_country_iso_code;
END IF;
- IF (v_subdivision_name != '') THEN
+ IF v_subdivision_name != '' THEN
SELECT id INTO v_divison_id FROM core_geoip_division WHERE name = v_subdivision_name AND country_id = v_country_id;
END IF;