add exporting of SQLite table

[nominatim.git] / nominatim / tokenizer / icu_tokenizer.py

diff --git a/nominatim/tokenizer/icu_tokenizer.py b/nominatim/tokenizer/icu_tokenizer.py
index 39c1cbc648ca33fe4ecce4ec77421db1de96b1c2..799ff559b94599c43e4f66270f82ec94ac0138cc 100644 (file)
--- 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,))