remove now useless getNearestPostcode function

Most postcodes are not in the location-area tables anymore.

diff --git a/sql/functions.sql b/sql/functions.sql
index 5e16a175007f85345b5dd0838b6ff54e2730e6e7..fd71c6fdd7c6ef9288622a4a3713022c1713e3ce 100644 (file)
--- a/sql/functions.sql
+++ b/sql/functions.sql
@@ -2683,9 +2683,7 @@ BEGIN
   IF out_postcode IS NULL THEN
     SELECT postcode from placex where place_id = out_parent_place_id INTO out_postcode;
   END IF;
-  IF out_postcode IS NULL THEN
-    out_postcode := getNearestPostcode(out_partition, place_centroid);
-  END IF;
+  -- XXX look into postcode table
 
   newpoints := 0;
   insert into location_property_aux (place_id, partition, parent_place_id, housenumber, postcode, centroid)

diff --git a/sql/partition-functions.src.sql b/sql/partition-functions.src.sql
index 7d4f7cbef3cb7f68864a551d85362832cde08e0f..f4df9135c681c4590887afe1b85ea9578e965b89 100644 (file)
--- a/sql/partition-functions.src.sql
+++ b/sql/partition-functions.src.sql
@@ -173,29 +173,6 @@ $$
 LANGUAGE plpgsql;
 
 
-create or replace function getNearestPostcode(in_partition INTEGER, point GEOMETRY) 
-  RETURNS TEXT AS $$
-DECLARE
-  out_postcode TEXT;
-BEGIN
-
--- start
-  IF in_partition = -partition- THEN
-    SELECT postcode
-        FROM location_area_large_-partition- join placex using (place_id)
-        WHERE st_contains(location_area_large_-partition-.geometry, point)
-        AND class = 'place' and type = 'postcode' 
-      ORDER BY st_distance(location_area_large_-partition-.centroid, point) ASC limit 1
-      INTO out_postcode;
-    RETURN out_postcode;
-  END IF;
--- end
-
-  RAISE EXCEPTION 'Unknown partition %', in_partition;
-END
-$$
-LANGUAGE plpgsql;
-
 create or replace function insertSearchName(
   in_partition INTEGER, in_place_id BIGINT, in_country_code VARCHAR(2), 
   in_name_vector INTEGER[], in_nameaddress_vector INTEGER[],