X-Git-Url: https://git.openstreetmap.org/nominatim.git/blobdiff_plain/95df39c2929b50f38a35f9f53ac4b983a4948787..3e9fb0dc84c2e5309ee9e094cd8930e11c39fc44:/sql/functions.sql diff --git a/sql/functions.sql b/sql/functions.sql index 721e0b1b..1cda2e98 100644 --- a/sql/functions.sql +++ b/sql/functions.sql @@ -2892,7 +2892,7 @@ BEGIN IF ST_GeometryType(placegeom) in ('ST_Polygon','ST_MultiPolygon') THEN FOR geom IN select split_geometry(placegeom) FROM placex WHERE place_id = placeid LOOP update placex set indexed_status = 2 where (st_covers(geom, placex.geometry) OR ST_Intersects(geom, placex.geometry)) - AND rank_search > rank and indexed_status = 0 and ST_geometrytype(placex.geometry) = 'ST_Point' and (rank_search < 28 or name is not null or (rank >= 16 and address > 'place')); + AND rank_search > rank and indexed_status = 0 and ST_geometrytype(placex.geometry) = 'ST_Point' and (rank_search < 28 or name is not null or (rank >= 16 and address ? 'place')); update placex set indexed_status = 2 where (st_covers(geom, placex.geometry) OR ST_Intersects(geom, placex.geometry)) AND rank_search > rank and indexed_status = 0 and ST_geometrytype(placex.geometry) != 'ST_Point' and (rank_search < 28 or name is not null or (rank >= 16 and address ? 'place')); END LOOP;