Project

General

Profile

« Previous | Next » 

Revision 11740

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/CVS/taxonObservation_/postprocess.sql: added _parent index to facilitate joins

View differences:

inputs/CVS/taxonObservation_/postprocess.sql
1 1 
SELECT util.search_path_append('util');
2 2 

  		




  
  3
  
    
SELECT create_if_not_exists($$CREATE INDEX $$||:table_str||%'_parent'||$$ ON $$||:table_str||$$ ("OBSERVATION_ID")$$); -- runtime: 1 s ("795.083 ms") @starscream


  		




  
  4
  
    

  		




  
  5
  
    

  		




  3
  6
  
    
UPDATE :table SET


  		




  4
  7
  
    
denorm_kingdom = "Kingdom"


  		




  5
  8
  
    
WHERE denorm_kingdom != "Kingdom"/*implies both NOT NULL*/ -- applies to 1 row (PLANTCONCEPT_ID 92372)


  		












Also available in:  Unified diff