Project

General

Profile

« Previous | Next » 

Revision 10948

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/FIA/occurrence_all/postprocess.sql: renamed occurrence_all--row_num to just row_num because this is for the entire view, rather than a specific table in it, and thus does not need a disambiguating table prefix. this also avoids embedding the view name in its own columns.

View differences:

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

  		




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


  		




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


  		




  
  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 */


  		




  7
  7
  
    
FROM              "TREE"


  		




  ......




  16
  16
  
    
NATURAL LEFT JOIN "REF_RESEARCH_STATION"


  		




  17
  17
  
    
$$);


  		




  18
  18
  
    

  		




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


  		




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


  		












Also available in:  Unified diff