Changeset 99 for trunk/data/konvert


Ignore:
Timestamp:
07/04/11 17:02:46 (10 years ago)
Author:
astrid.emde
Message:

new table delete and function to delete features

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/data/konvert/transaction_delete.sql

    r98 r99  
    99  featureid character(32), 
    1010  CONSTRAINT delete_pk PRIMARY KEY (ogc_fid) 
    11 ) 
    12 WITH ( 
    13   OIDS=TRUE 
    1411); 
    15 ALTER TABLE "delete" OWNER TO postgres; 
    1612 
    1713DROP FUNCTION deletefeature(text, text); 
     
    3632$$ LANGUAGE plpgsql;  
    3733 
    38  
    39 INSERT INTO AA_Antragsgebiet (gml_id) VALUES ('DENW44AL0000okRc'); 
    40  
    41 INSERT INTO delete (typename, featureid) VALUES ('AA_Antragsgebiet','DENW44AL0000okRc20110428T135110Z'); 
    42  
    43 Select deleteFeature('AA_Antragsgebiet','DENW44AL0000okRc20110428T135110Z'); 
    44  
    45 INSERT INTO AA_Antragsgebiet (gml_id) VALUES ('DENW44AL0000okRc'); 
    46  
    47 Select * from AA_Antragsgebiet 
    48  
    49 Select substring('DENW44AL0000okRc20110428T135110Z' from 1 for 16) 
     34-- example 
     35--INSERT INTO AA_Antragsgebiet (gml_id) VALUES ('DENW44AL0000okRc'); 
     36--INSERT INTO delete (typename, featureid) VALUES ('AA_Antragsgebiet','DENW44AL0000okRc20110428T135110Z'); 
     37--Select deleteFeature('AA_Antragsgebiet','DENW44AL0000okRc20110428T135110Z'); 
     38--INSERT INTO AA_Antragsgebiet (gml_id) VALUES ('DENW44AL0000okRc'); 
     39--Select * from AA_Antragsgebiet 
    5040 
    5141Select deleteFeature(typename,featureid) from delete; 
Note: See TracChangeset for help on using the changeset viewer.