Project

General

Profile

« Previous | Next » 

Revision 13110

Added by Aaron Marcuse-Kubitza over 10 years ago

bugfix: inputs/NY/validations.sql: specimens*_of_verbatim_subspecific_taxa_with_author: need `subspecies IS NOT NULL` filter

View differences:

trunk/inputs/NY/validations.sql
112 112 
CREATE VIEW _specimens_06_count_of_unique_verb_subsp_taxa_with_author AS
113 113 
 SELECT count(DISTINCT concat_ws(' '::text, "Ecatalog_all".genus, "Ecatalog_all"."specificEpithet", "Ecatalog_all".subspecies)) AS taxon_names_with_author
114 114 
   FROM "Ecatalog_all"
115 
  WHERE (("Ecatalog_all".genus IS NOT NULL) AND ("Ecatalog_all"."specificEpithet" IS NOT NULL));
115 
  WHERE ((("Ecatalog_all".genus IS NOT NULL) AND ("Ecatalog_all"."specificEpithet" IS NOT NULL)) AND ("Ecatalog_all".subspecies IS NOT NULL));
116 116 

  		




  117
  117
  
    

  		




  118
  118
  
    
--


  		




  ......




  131
  131
  
    
CREATE VIEW _specimens_07_list_of_verbatim_subspecific_taxa_with_author AS


  		




  132
  132
  
    
 SELECT DISTINCT concat_ws(' '::text, "Ecatalog_all".genus, "Ecatalog_all"."specificEpithet", "Ecatalog_all".subspecies) AS taxon_name_with_author


  		




  133
  133
  
    
   FROM "Ecatalog_all"


  		




  134
  
  
    
  WHERE (("Ecatalog_all".genus IS NOT NULL) AND ("Ecatalog_all"."specificEpithet" IS NOT NULL));


  		




  
  134
  
    
  WHERE ((("Ecatalog_all".genus IS NOT NULL) AND ("Ecatalog_all"."specificEpithet" IS NOT NULL)) AND ("Ecatalog_all".subspecies IS NOT NULL));


  		




  135
  135
  
    

  		




  136
  136
  
    

  		




  137
  137
  
    
--


  		












Also available in:  Unified diff