Project

General

Profile

« Previous | Next » 

Revision 10380

Added by Aaron Marcuse-Kubitza almost 11 years ago

inputs/BRIT/specimen_flat/: translated single-column filters to postprocessing derived columns, using the steps at wiki.vegpath.org/Switching_to_new-style_import#stage-I-source-specific > "translate single-column filters to postprocessing derived columns"

View differences:

postprocess.sql
1 1 
SELECT util.search_path_append('util');
2 2 

  		




  3
  3
  
    
SELECT create_if_not_exists($$ALTER TABLE $$||:table_str||$$ ADD PRIMARY KEY (specimen_id)$$);


  		




  
  4
  
    

  		




  
  5
  
    
SELECT mk_derived_col((:table_str, 'occurrenceRemarks'),


  		




  
  6
  
    
$$CASE WHEN "Locality_Description" IS NOT NULL THEN "Notes_Plant" END$$)


  		




  
  7
  
    
; -- runtime: 0.3 s ("Time: 311.190 ms") @starscream


  		












Also available in:  Unified diff