X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/edebf5f1b21e448a2a43de9e91aa9629565ca321..0b755473bfa03610541c260e628b5d567b627b16:/sql/partition-functions.src.sql?ds=sidebyside 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