Project

General

Profile

« Previous | Next » 

Revision 12068

Added by Aaron Marcuse-Kubitza almost 11 years ago

validation/aggregating/*/*.sql (the output queries): added `SET search_path TO validation`

View differences:

trunk/validation/aggregating/plots/bien3_validations_salvias_vegbien.sql
18 18 
-- Currently configured for SALVIAS
19 19 
-- ------------------
20 20 

  		




  
  21
  
    
SET search_path TO validation;


  		




  
  22
  
    

  		




  21
  23
  
    
-- datasource


  		




  22
  24
  
    
\set ds '\'SALVIAS\'' 


  		




  23
  25
  
    

  		












  

    
      trunk/validation/aggregating/specimens/qualitative_validations_specimens.sql
    
  





  7
  7
  
    
-- Host: vegbiendev.nceas.ucsb.edu


  		




  8
  8
  
    
-- -------------------------------------------------------------------------


  		




  9
  9
  
    

  		




  
  10
  
    
SET search_path TO validation;


  		




  
  11
  
    

  		




  10
  12
  
    
-- -------------------------------


  		




  11
  13
  
    
-- 1. Count of total records (specimens) in source db


  		




  12
  14
  
    
-- Check: full join against equivalent query on BIEN3 db should return 1 row


  		












  

    
      trunk/validation/aggregating/traits/bien3_validations_traits_bien3.sql
    
  





  5
  5
  
    
-- Host: vegbiendev.nceas.ucsb.edu


  		




  6
  6
  
    
-- -------------------------------------------------------------------------------


  		




  7
  7
  
    

  		




  
  8
  
    
SET search_path TO validation;


  		




  
  9
  
    

  		




  8
  10
  
    
-- ------------------


  		




  9
  11
  
    
-- 1. Count records


  		




  10
  12
  
    
-- ------------------


  		












Also available in:  Unified diff