Project

General

Profile

« Previous | Next » 

Revision 12745

Added by Aaron Marcuse-Kubitza almost 11 years ago

fix: inputs/*/*/postprocess.sql: un-doubled *

View differences:

trunk/inputs/CVS/taxonObservation_/postprocess.sql
5 5 

  		




  6
  6
  
    
UPDATE :table SET


  		




  7
  7
  
    
kingdom = "DUPLICATE#of:denorm_kingdom#Kingdom"


  		




  8
  
  
    
WHERE kingdom != "DUPLICATE#of:denorm_kingdom#Kingdom"/*implies both NOT NULL*/ -- applies to 1 row (**PLANTCONCEPT_ID 92372)


  		




  
  8
  
    
WHERE kingdom != "DUPLICATE#of:denorm_kingdom#Kingdom"/*implies both NOT NULL*/ -- applies to 1 row (*PLANTCONCEPT_ID 92372)


  		




  9
  9
  
    
; -- rerun time: 0.5 s ("710.176 ms") @starscream; runtime: 2 s ("2211.789 ms") @starscream


  		




  10
  10
  
    

  		




  11
  11
  
    
UPDATE :table SET


  		












Also available in:  Unified diff