Project

General

Profile

« Previous | Next » 

Revision 11012

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/VegBank/taxon_observation.**/postprocess.sql: run mk_subset_by_row_num_func() to add a subset function that uses sort_col. this is used by column-based import, and also provides a common subsetting/sorting API for all the left-joined views. test.xml.ref: the inserted row count most likely changes because the sort order changes.

View differences:

inputs/VegBank/taxon_observation.**/postprocess.sql
10 10 
NATURAL LEFT JOIN observation_
11 11 
NATURAL LEFT JOIN plot_
12 12 
$$);
13 

  		




  
  14
  
    
SELECT mk_subset_by_row_num_func(:table_str);


  		












  

    
      inputs/VegBank/taxon_observation.**/test.xml.ref
    
  





  249
  249
  
    
        </path>


  		




  250
  250
  
    
    </_setDefault>


  		




  251
  251
  
    
</VegBIEN>


  		




  252
  
  
    
Inserted 19 new rows into database


  		




  
  252
  
    
Inserted 21 new rows into database


  		












Also available in:  Unified diff