Merge remote-tracking branch 'upstream/master'

[nominatim.git] / sql / functions.sql

diff --git a/sql/functions.sql b/sql/functions.sql
index 1efb189938fffdbc1d97f95d166b0e101647656a..18e8bdbc5278d10226cc9c97a209035f2c3a5a37 100644 (file)
--- a/sql/functions.sql
+++ b/sql/functions.sql
@@ -2124,28 +2124,27 @@ BEGIN
 END; 
 $$ LANGUAGE plpgsql;
 
 END; 
 $$ LANGUAGE plpgsql;
 

+

 CREATE OR REPLACE FUNCTION get_name_by_language(name hstore, languagepref TEXT[]) RETURNS TEXT
   AS $$
 DECLARE
 CREATE OR REPLACE FUNCTION get_name_by_language(name hstore, languagepref TEXT[]) RETURNS TEXT
   AS $$
 DECLARE

-  search TEXT[];
-  found BOOLEAN;
+  result TEXT;

 BEGIN
 BEGIN

-

   IF name is null THEN
     RETURN null;
   END IF;
 
   IF name is null THEN
     RETURN null;
   END IF;
 

-  search := languagepref;
-
-  FOR j IN 1..array_upper(search, 1) LOOP
-    IF name ? search[j] AND trim(name->search[j]) != '' THEN
-      return trim(name->search[j]);
+  FOR j IN 1..array_upper(languagepref,1) LOOP
+    IF name ? languagepref[j] THEN
+      result := trim(name->languagepref[j]);
+      IF result != '' THEN
+        return result;
+      END IF;

     END IF;
   END LOOP;
 
   -- anything will do as a fallback - just take the first name type thing there is
     END IF;
   END LOOP;
 
   -- anything will do as a fallback - just take the first name type thing there is

-  search := avals(name);
-  RETURN search[1];
+  RETURN trim((avals(name))[1]);

 END;
 $$
 LANGUAGE plpgsql IMMUTABLE;
 END;
 $$
 LANGUAGE plpgsql IMMUTABLE;