X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/f29dc7d7ac61ad4408655a8d195d8424de13ebc9..c5c7a6a45368b4818e5e3e83c0f010db7c0dec95:/sql/partition-functions.src.sql?ds=sidebyside diff --git a/sql/partition-functions.src.sql b/sql/partition-functions.src.sql index 17db9c16..e2342a9c 100644 --- a/sql/partition-functions.src.sql +++ b/sql/partition-functions.src.sql @@ -44,7 +44,7 @@ BEGIN FROM location_area_large_-partition- WHERE geometry && feature AND is_relevant_geometry(ST_Relate(geometry, feature), ST_GeometryType(feature)) - AND rank_search < maxrank AND rank_address < maxrank + AND rank_address < maxrank GROUP BY place_id, keywords, rank_address, rank_search, isguess, postcode, centroid ORDER BY rank_address, isin_tokens && keywords desc, isguess asc, ST_Distance(feature, centroid) * @@ -160,7 +160,7 @@ BEGIN FROM search_name_-partition- WHERE name_vector && isin_token AND centroid && ST_Expand(point, 0.04) - AND search_rank between 16 and 22 + AND search_rank between 16 and 25 ORDER BY ST_Distance(centroid, point) ASC limit 1; RETURN parent; END IF;