Project

General

Profile

« Previous | Next » 

Revision 13061

Added by Aaron Marcuse-Kubitza almost 11 years ago

validation/aggregating/**.sql output queries: use `SET join_collapse_limit = 1;` to match public_validations.rematerialize_out_view()

View differences:

trunk/validation/aggregating/plots/bien3_validations_salvias_vegbien.sql
20 20 
\set datasource '''SALVIAS'''
21 21 

  		




  22
  22
  
    
SET enable_seqscan = off;


  		




  
  23
  
    
SET join_collapse_limit = 1; -- turn it off


  		




  23
  24
  
    

  		




  24
  25
  
    
-- _plots_01_count_of_projects


  		




  25
  26
  
    
 SELECT count(*) AS projects


  		












  

    
      trunk/validation/aggregating/specimens/qualitative_validations_specimens.sql
    
  





  12
  12
  
    
SET search_path TO public_validations, public;


  		




  13
  13
  
    

  		




  14
  14
  
    
SET enable_seqscan = off;


  		




  
  15
  
    
SET join_collapse_limit = 1; -- turn it off


  		




  15
  16
  
    

  		




  16
  17
  
    
CREATE VIEW _specimens_01_count_of_total_records_specimens_in_source_db AS


  		




  17
  18
  
    
SELECT count(*) AS "totalSpecimenRecords"


  		




  ......




  94
  95
  
    
Note: character set issues may cause mis-matches. This query is a good way to reveal character set issues, either in source db or in BIEN


  		




  95
  96
  
    
';


  		




  96
  97
  
    

  		




  97
  
  
    
SET join_collapse_limit = 1; -- turn it off


  		




  98
  98
  
    
CREATE VIEW _specimens_12_distinct_collector_name_collect_num_date_w_count AS


  		




  99
  99
  
    
SELECT


  		




  100
  100
  
    
  (SELECT fullname FROM party WHERE party.party_id = collector_id) AS "collectorName"


  		




  ......




  109
  109
  
    
GROUP BY "collectorName", "collectionNumber", "dateCollected"


  		




  110
  110
  
    
ORDER BY "collectorName", "collectionNumber", "dateCollected"


  		




  111
  111
  
    
;


  		




  112
  
  
    
RESET join_collapse_limit;


  		




  113
  112
  
    

  		




  114
  113
  
    
CREATE VIEW _specimens_13_count_of_all_verbatim_and_decimal_lat_long AS


  		




  115
  114
  
    
SELECT


  		












  

    
      trunk/validation/aggregating/traits/bien3_validations_traits_bien3.sql
    
  





  7
  7
  
    

  		




  8
  8
  
    
SET search_path TO public_validations, public;


  		




  9
  9
  
    

  		




  
  10
  
    
SET enable_seqscan = off;


  		




  
  11
  
    
SET join_collapse_limit = 1; -- turn it off


  		




  
  12
  
    

  		




  10
  13
  
    
-- ------------------


  		




  11
  14
  
    
-- 1. Count records


  		




  12
  15
  
    
-- ------------------


  		












Also available in:  Unified diff