]> git.openstreetmap.org Git - nominatim.git/blobdiff - sql/functions/utils.sql
Merge pull request #1857 from mtmail/db-migration-update-functions
[nominatim.git] / sql / functions / utils.sql
index 2b3db04a92116b38c4f0504f1372923d313ed897..33ae340a601666f91fbaf20c3715460d633064c4 100644 (file)
@@ -467,7 +467,7 @@ DECLARE
   placegeom GEOMETRY;
   geom GEOMETRY;
   diameter FLOAT;
   placegeom GEOMETRY;
   geom GEOMETRY;
   diameter FLOAT;
-  rank INTEGER;
+  rank SMALLINT;
 BEGIN
   UPDATE placex SET indexed_status = 2 WHERE place_id = placeid;
   SELECT geometry, rank_search FROM placex WHERE place_id = placeid INTO placegeom, rank;
 BEGIN
   UPDATE placex SET indexed_status = 2 WHERE place_id = placeid;
   SELECT geometry, rank_search FROM placex WHERE place_id = placeid INTO placegeom, rank;