Project

General

Profile

« Previous | Next » 

Revision 10949

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/FIA/occurrence_all/postprocess.sql: use :table_str var instead of hardcoding the table name as occurrence_all, to avoid needing to change this file when renaming the view

View differences:

inputs/FIA/occurrence_all/postprocess.sql
1 1 
SELECT util.search_path_append('util');
2 2 

  		




  3
  
  
    
SELECT force_update_view('"occurrence_all"', $$


  		




  
  3
  
    
SELECT force_update_view(:table_str, $$


  		




  4
  4
  
    
SELECT "*TREE--row_num" AS "row_num", *


  		




  5
  5
  
    
/* directional joins ensure that the PostgreSQL query planner always joins


  		




  6
  6
  
    
starting with the TREE table */


  		




  ......




  16
  16
  
    
NATURAL LEFT JOIN "REF_RESEARCH_STATION"


  		




  17
  17
  
    
$$);


  		




  18
  18
  
    

  		




  19
  
  
    
SELECT mk_subset_by_row_num_func('"occurrence_all"', 'row_num');


  		




  
  19
  
    
SELECT mk_subset_by_row_num_func(:table_str, 'row_num');


  		












Also available in:  Unified diff