From: Sarah Hoffmann <lonvia@denofr.de>
Date: Fri, 26 Feb 2021 17:23:24 +0000 (+0100)
Subject: older versions of Postgresql need explicit return type
X-Git-Tag: v3.7.0~29^2~1
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/afabbeb546b94bfcdc1b5fbba37c04b5e07b54ed?ds=inline

older versions of Postgresql need explicit return type
---

diff --git a/test/python/test_tools_database_import.py b/test/python/test_tools_database_import.py
index f9760fc0..45324834 100644
--- a/test/python/test_tools_database_import.py
+++ b/test/python/test_tools_database_import.py
@@ -189,7 +189,7 @@ def test_load_data(dsn, src_dir, place_row, placex_table, osmline_table, word_ta
                    temp_db_cursor, threads):
     for func in ('make_keywords', 'getorcreate_housenumber_id', 'make_standard_name'):
         temp_db_cursor.execute("""CREATE FUNCTION {} (src TEXT)
-                                  RETURNS TEXT AS $$ SELECT 'a' $$ LANGUAGE SQL
+                                  RETURNS TEXT AS $$ SELECT 'a'::TEXT $$ LANGUAGE SQL
                                """.format(func))
     for oid in range(100, 130):
         place_row(osm_id=oid)