Project

General

Profile

« Previous | Next » 

Revision 11749

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/CVS/: switched to new-style import, using the steps at http://wiki.vegpath.org/Adding_new-style_import_to_a_datasource

View differences:

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

  		




  3
  
  
    
SELECT util.rename_cols(:table_str, $$


  		




  4
  
  
    
genus => *genus,


  		




  5
  
  
    
$$::hstore);


  		




  
  3
  
    
SELECT create_if_not_exists($$ALTER TABLE $$||:table_str||$$ ADD PRIMARY KEY ("*PLANTCONCEPT_ID")$$); -- runtime: ~0 @starscream


  		




  6
  4
  
    

  		




  7
  
  
    
SELECT create_if_not_exists($$ALTER TABLE $$||:table_str||$$ ADD PRIMARY KEY ("PLANTCONCEPT_ID")$$); -- runtime: ~0 @starscream


  		




  8
  5
  
    

  		




  9
  
  
    

  		




  10
  6
  
    
SELECT mk_derived_col((:table_str, 'division'),


  		




  11
  
  
    
$$_alt(denorm_division, "Division")$$)


  		




  
  7
  
    
$$_alt(division_main, division_normalized)$$)


  		




  12
  8
  
    
; -- runtime: 0.2 s ("212.478 ms") @starscream


  		




  13
  9
  
    

  		




  14
  10
  
    
SELECT mk_derived_col((:table_str, 'genus'),


  		




  15
  
  
    
$$_alt(denorm_genus, "*genus")$$)


  		




  
  11
  
    
$$_alt(genus_main, genus_normalized)$$)


  		




  16
  12
  
    
; -- runtime: 0.1 s ("127.546 ms") @starscream


  		












Also available in:  Unified diff