X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/be47cd2549da482f3a408307eee8bfe7967cff25..bc68ff1e43f2527039640b8642bbe533814a3561:/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