Project

General

Profile

« Previous | Next » 

Revision 13109

Added by Aaron Marcuse-Kubitza over 10 years ago

bugfix: inputs/NY/validations.sql: _specimens_07_list_of_verbatim_subspecific_taxa_with_author: need to include subspecies (as _specimens_06_count_of_unique_verb_subsp_taxa_with_author does)

View differences:

validations.sql
129 129 
--
130 130 

  		




  131
  131
  
    
CREATE VIEW _specimens_07_list_of_verbatim_subspecific_taxa_with_author AS


  		




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


  		




  
  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
  134
  
    
  WHERE (("Ecatalog_all".genus IS NOT NULL) AND ("Ecatalog_all"."specificEpithet" IS NOT NULL));


  		




  135
  135
  
    

  		












Also available in:  Unified diff