From: Sarah Hoffmann <lonvia@denofr.de>
Date: Wed, 26 Jul 2023 15:45:21 +0000 (+0200)
Subject: older version of Postgres cannot convert jsonb to int
X-Git-Tag: v4.3.0~48^2
X-Git-Url: https://git.openstreetmap.org/nominatim.git/commitdiff_plain/8cba65809c509151165ae4dcc8c180711fd71470

older version of Postgres cannot convert jsonb to int
---

diff --git a/nominatim/tokenizer/icu_tokenizer.py b/nominatim/tokenizer/icu_tokenizer.py
index 39c1cbc6..799ff559 100644
--- a/nominatim/tokenizer/icu_tokenizer.py
+++ b/nominatim/tokenizer/icu_tokenizer.py
@@ -188,7 +188,7 @@ class ICUTokenizer(AbstractTokenizer):
             in the database.
         """
         with conn.cursor() as cur:
-            cur.execute("""SELECT word, sum((info->'count')::int) as count
+            cur.execute("""SELECT word, sum((info->>'count')::int) as count
                              FROM word WHERE type = 'W'
                              GROUP BY word
                              ORDER BY count DESC LIMIT %s""", (num,))