Project

General

Profile

« Previous | Next » 

Revision 12060

Added by Aaron Marcuse-Kubitza almost 11 years ago

inputs/bien2_traits/TraitObservation/postprocess.sql: remove rows with no taxon name, which are invalid, and which helps simplify the aggregating validations queries

View differences:

trunk/inputs/bien2_traits/TraitObservation/postprocess.sql
1 
SELECT util.search_path_append('util');
2 

  		




  
  3
  
    

  		




  
  4
  
    
-- remove invalid rows


  		




  
  5
  
    

  		




  
  6
  
    
-- remove rows with no taxon name


  		




  
  7
  
    
-- this also helps simplify the aggregating validations queries


  		




  
  8
  
    
DELETE FROM :table WHERE "taxonName" IS NULL


  		




  
  9
  
    
-- removes 12571 of 122230 rows (122230 - 109659)


  		




  
  10
  
    
; -- runtime: 0.3 s ("288.312 ms") @starscream


  		












Also available in:  Unified diff