Project

General

Profile

« Previous | Next » 

Revision 13089

Added by Aaron Marcuse-Kubitza over 10 years ago

bugfix: inputs/NY/validations.sql: _specimens_03_list_of_verbatim_families: use family as specified in query description, not as implemented

View differences:

validations.sql
53 53 
--
54 54 

  		




  55
  55
  
    
CREATE VIEW _specimens_03_list_of_verbatim_families AS


  		




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


  		




  
  56
  
    
 SELECT DISTINCT "Ecatalog_all".family


  		




  57
  57
  
    
   FROM "Ecatalog_all"


  		




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


  		




  59
  59
  
    

  		












Also available in:  Unified diff