Project

General

Profile

« Previous | Next » 

Revision 13390

Added by Aaron Marcuse-Kubitza over 10 years ago

bugfix: schemas/public_.sql: _plots_21_tnrs_output_names: need to use TNRS output rather than input name

View differences:

public_.sql
9400 9400 
--
9401 9401 

  		




  9402
  9402
  
    
CREATE VIEW _plots_21_tnrs_output_names AS


  		




  9403
  
  
    
 SELECT DISTINCT taxon_scrub."concatenatedScientificName" AS tnrs_output_name


  		




  
  9403
  
    
 SELECT DISTINCT taxon_scrub.scrubbed_taxon_name_no_author AS tnrs_output_name


  		




  9404
  9404
  
    
   FROM (public.taxonlabel


  		




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


  		




  9406
  9406
  
    
  WHERE ((taxonlabel.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname)) AND (taxon_scrub."concatenatedScientificName" IS NOT NULL));


  		












Also available in:  Unified diff