X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/7c7d15fe82f5516f6d65308bb6318618921fb2dc..e43be005ed08ca5bbd0b095310df362fb940c801:/lib-sql/functions/address_lookup.sql diff --git a/lib-sql/functions/address_lookup.sql b/lib-sql/functions/address_lookup.sql index 3e25c6fc..7fb11cfb 100644 --- a/lib-sql/functions/address_lookup.sql +++ b/lib-sql/functions/address_lookup.sql @@ -43,8 +43,8 @@ BEGIN END IF; END LOOP; - -- anything will do as a fallback - just take the first name type thing there is - RETURN trim((avals(name))[1]); + -- as a fallback - take the last element since it is the default name + RETURN trim((avals(name))[array_length(avals(name), 1)]); END; $$ LANGUAGE plpgsql IMMUTABLE;