Project

General

Profile

« Previous | Next » 

Revision 13432

Added by Aaron Marcuse-Kubitza over 10 years ago

schemas/public_.sql: _plots_20_tnrs_names: added verbatim name in order to also validate the formation of the concatenated name

View differences:

public_.sql
9390 9390 
--
9391 9391 

  		




  9392
  9392
  
    
CREATE VIEW _plots_20_tnrs_names AS


  		




  9393
  
  
    
 SELECT DISTINCT ON (taxonlabel.taxonomicname) taxonlabel.taxonomicname AS tnrs_input_name, 


  		




  
  9393
  
    
 SELECT taxonlabel.taxonomicname AS verbatim_name_with_author, 


  		




  
  9394
  
    
    taxonlabel.taxonomicname AS tnrs_input_name, 


  		




  9394
  9395
  
    
    taxon_scrub.scrubbed_unique_taxon_name AS tnrs_output_name


  		




  9395
  
  
    
   FROM (public.taxonlabel


  		




  
  9396
  
    
   FROM ((public.taxonverbatim


  		




  
  9397
  
    
   JOIN public.taxonlabel USING (taxonlabel_id))


  		




  9396
  9398
  
    
   JOIN "TNRS".taxon_scrub ON ((taxon_scrub."concatenatedScientificName" = taxonlabel.taxonomicname)))


  		




  9397
  
  
    
  WHERE ((taxonlabel.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname)) AND (taxonlabel.taxonomicname IS NOT NULL))


  		




  
  9399
  
    
  WHERE (taxonverbatim.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname))


  		




  9398
  9400
  
    
  ORDER BY taxonlabel.taxonomicname;


  		




  9399
  9401
  
    

  		




  9400
  9402
  
    

  		












Also available in:  Unified diff