X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/15bca71b0de68c38cd27d29a9ab19bf9832b9f56..dae2761137c5ee95daf495e5cdf459fd8c7c17b4:/sql/partition-functions.src.sql diff --git a/sql/partition-functions.src.sql b/sql/partition-functions.src.sql index 20f71584..f770e83e 100644 --- a/sql/partition-functions.src.sql +++ b/sql/partition-functions.src.sql @@ -95,7 +95,7 @@ BEGIN ST_Distance(centroid, point) as distance, null as isguess FROM search_name_-partition- WHERE name_vector && isin_token - AND ST_DWithin(centroid, point, 0.015) + AND centroid && ST_Expand(point, 0.015) AND search_rank between 26 and 27 ORDER BY distance ASC limit 1 LOOP @@ -123,7 +123,7 @@ BEGIN ST_Distance(centroid, point) as distance, null as isguess FROM search_name_-partition- WHERE name_vector && isin_token - AND ST_DWithin(centroid, point, 0.04) + AND centroid && ST_Expand(point, 0.04) AND search_rank between 16 and 22 ORDER BY distance ASC limit 1 LOOP