Project

General

Profile

« Previous | Next » 

Revision 10993

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/VegBank/taxonobservation_/postprocess.sql: added primary key. note that the inserted row count changes, most likely because the rows are now in sorted order.

View differences:

postprocess.sql
4 4 
SELECT mk_derived_col((:table_str, 'scientificName'),
5 5 
$$_alt("scientificName_verbatim", "scientificName__for_nearest_taxon_concept")$$)
6 6 
; -- runtime: 15 s ("Time: 12334.893 ms") @starscream
7 

  		




  
  8
  
    
SELECT mk_derived_col((:table_str, 'identificationID'),


  		




  
  9
  
    
$$_join("taxonOccurrenceID"::text, "identificationID__taxon_determination"::text)$$)


  		




  
  10
  
    
; -- runtime: 20 s ("Time: 21724.277 ms") @starscream


  		




  
  11
  
    

  		




  
  12
  
    

  		




  
  13
  
    
SELECT create_if_not_exists($$ALTER TABLE $$||:table_str||$$ ADD PRIMARY KEY ("identificationID")$$); -- runtime: 20 s ("Time: 19328.716 ms") @starscream


  		












Also available in:  Unified diff