From: Sarah Hoffmann <lonvia@denofr.de>
Date: Tue, 13 Oct 2020 20:36:17 +0000 (+0200)
Subject: exclude rank 25 when computing addresses of streets
X-Git-Tag: v3.6.0~50^2~7
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/e47c19beb94c9f7f1fbff1ba7b89a04cb0759ed3?ds=sidebyside;hp=2fe3c654fc96eb72047c0d2dd2beadc840ad48b4

exclude rank 25 when computing addresses of streets

Address rank 25 is used for squares which are address-wise on the
same level as streets.
---

diff --git a/sql/functions/placex_triggers.sql b/sql/functions/placex_triggers.sql
index aac7cafc..d8472824 100644
--- a/sql/functions/placex_triggers.sql
+++ b/sql/functions/placex_triggers.sql
@@ -895,8 +895,9 @@ BEGIN
   END IF;
 
   SELECT * FROM insert_addresslines(NEW.place_id, NEW.partition,
-                                    CASE WHEN NEW.rank_address = 0
-                                      THEN NEW.rank_search ELSE NEW.rank_address END,
+                                    CASE WHEN NEW.rank_address = 0 THEN NEW.rank_search
+                                         WHEN NEW.rank_address > 25 THEN 25::smallint
+                                         ELSE NEW.rank_address END,
                                     NEW.address,
                                     CASE WHEN NEW.rank_search >= 26
                                              AND NEW.rank_search < 30