From 2edefd9e80ac27600dbd2fdebfa29735b29587d8 Mon Sep 17 00:00:00 2001
From: Sarah Hoffmann <lonvia@denofr.de>
Date: Wed, 1 Jul 2020 15:46:08 +0200
Subject: [PATCH] sql: fix rank variable type

The rank type needs to match the parameter type of
update_place_diameter().

Fixes #1851.
---
 sql/functions/utils.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/sql/functions/utils.sql b/sql/functions/utils.sql
index 2b3db04a..33ae340a 100644
--- a/sql/functions/utils.sql
+++ b/sql/functions/utils.sql
@@ -467,7 +467,7 @@ DECLARE
   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;
-- 
2.39.5