X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/e4796bb876bf75dd674ee3f25a89bebb7e037443..6eb1113dcb569f07367a801e6ac2dcb9565ec7b8:/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;