lower significance of postcodes in Singapure

Postcodes with 6 digits designate delivery points, i.e. houses.

diff --git a/sql/functions.sql b/sql/functions.sql
index 2c415620a40cf5dfa70cd6fc62bae646ba970e57..e2bfbbbccf76b6bb29c16b140841e83dd76bbb68 100644 (file)
--- a/sql/functions.sql
+++ b/sql/functions.sql
@@ -1018,6 +1018,13 @@ BEGIN
             NEW.rank_address := 5;
           END IF;
 
             NEW.rank_address := 5;
           END IF;
 

+        ELSEIF NEW.calculated_country_code = 'sg' THEN
+
+          IF NEW.postcode ~ '^([0-9]{6})$' THEN
+            NEW.rank_search := 25;
+            NEW.rank_address := 11;
+          END IF;
+

         ELSEIF NEW.calculated_country_code = 'de' THEN
 
           IF NEW.postcode ~ '^([0-9]{5})$' THEN
         ELSEIF NEW.calculated_country_code = 'de' THEN
 
           IF NEW.postcode ~ '^([0-9]{5})$' THEN