X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/15bca71b0de68c38cd27d29a9ab19bf9832b9f56..9905bbf733542af5f0ac1e3d827fbb353b446beb:/sql/partition-functions.src.sql?ds=inline 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