| 70 | = Import von Fortführungsdatensätzen = |
| 71 | |
| 72 | == == |
| 73 | |
| 74 | == Anlegen der Funktion deleteFeature == |
| 75 | {{{ |
| 76 | CREATE FUNCTION deleteFeature(typename text, featureid text) RETURNS text |
| 77 | AS $$ |
| 78 | DECLARE |
| 79 | query text; |
| 80 | res text; |
| 81 | BEGIN |
| 82 | query := 'DELETE FROM ' || $1 || ' WHERE gml_id = substring(''' || $2 || ''' from 1 for 16)'; |
| 83 | EXECUTE query; |
| 84 | |
| 85 | IF FOUND THEN |
| 86 | RAISE NOTICE 'query successfull % ', query; |
| 87 | res := 1; |
| 88 | ELSE |
| 89 | RAISE NOTICE 'query no object found % ', query; |
| 90 | res := 0; |
| 91 | END IF; |
| 92 | RETURN res; |
| 93 | END; |
| 94 | $$ LANGUAGE plpgsql; |
| 95 | }}} |
| 96 | |
| 97 | == Löschen der in der Tabelle delete vermekten Datensätze == |
| 98 | |
| 99 | {{{ |
| 100 | Select deleteFeature(typename, featureid) from delete; |
| 101 | }}} |
| 102 | |
| 103 | |
| 104 | == Laden der Fortführungsdaten == |
| 105 | |
| 106 | |
| 107 | == Löschen der Einträge der Tabelle delete == |
| 108 | |
| 109 | {{{ |
| 110 | Delete from delete; |
| 111 | }}} |
| 112 | |
| 113 | |