Project

General

Profile

« Previous | Next » 

Revision 13111

Added by Aaron Marcuse-Kubitza over 10 years ago

fix: inputs/NY/validations.sql: specimens*_of_unique_verb_subsp_taxa_with_author: use taxonName instead of concatenating the ranks, as that corresponds to what we use as the concatenated taxonomic name

View differences:

trunk/inputs/NY/validations.sql
110 110 
--
111 111 

  		




  112
  112
  
    
CREATE VIEW _specimens_06_count_of_unique_verb_subsp_taxa_with_author AS


  		




  113
  
  
    
 SELECT count(DISTINCT concat_ws(' '::text, "Ecatalog_all".genus, "Ecatalog_all"."specificEpithet", "Ecatalog_all".subspecies)) AS taxon_names_with_author


  		




  
  113
  
    
 SELECT count(DISTINCT "Ecatalog_all"."taxonName") AS taxon_names_with_author


  		




  114
  114
  
    
   FROM "Ecatalog_all"


  		




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


  		




  116
  116
  
    

  		




  ......




  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", "Ecatalog_all".subspecies) AS taxon_name_with_author


  		




  
  132
  
    
 SELECT DISTINCT "Ecatalog_all"."taxonName" 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)) AND ("Ecatalog_all".subspecies IS NOT NULL));


  		




  135
  135
  
    

  		












Also available in:  Unified diff