Changes between Version 16 and Version 17 of ATKIS

Timestamp:

09/20/11 15:36:32 (13 years ago)

Author:

armin.retterath

Comment:

--

ATKIS

@@ -122 +122 @@
   res text; 
  BEGIN 
-     query := 'DELETE FROM ' || lower($1) || ' WHERE gml_id = ''' || $2 || '''';
+     query := 'DELETE FROM ' || lower($1) || ' WHERE gml_id = ''' || substring($2 from 1 for 16) || '''';
      EXECUTE query;
-     query := 'DELETE FROM alkis_beziehungen WHERE beziehung_von = ''' || $2 || ''' OR beziehung_zu = ''' || $2 || '''';
+     query := 'DELETE FROM alkis_beziehungen WHERE beziehung_von = ''' || substring($2 from 1 for 16) || ''' OR beziehung_zu = ''' || substring($2 from 1 for 16) || '''';
      EXECUTE query;
-
      IF FOUND THEN 
         RAISE NOTICE 'query successfull % ', query;