Project

General

Profile

« Previous | Next » 

Revision 13522

Added by Aaron Marcuse-Kubitza over 10 years ago

bugfix: schemas/public_.sql: _plots_20_tnrs_names: verbatim_name_with_author: use taxonverbatim.taxonomicname rather than taxonlabel.taxonomicname

View differences:

trunk/schemas/public_.sql
9390 9390 
--
9391 9391 

  		




  9392
  9392
  
    
CREATE VIEW _plots_20_tnrs_names AS


  		




  9393
  
  
    
 SELECT taxonlabel.taxonomicname AS verbatim_name_with_author, 


  		




  
  9393
  
    
 SELECT taxonverbatim.taxonomicname AS verbatim_name_with_author, 


  		




  9394
  9394
  
    
    taxonlabel.taxonomicname AS tnrs_input_name, 


  		




  9395
  9395
  
    
    taxon_scrub."taxonomicStatus" AS tnrs_taxonomic_status, 


  		




  9396
  9396
  
    
    taxon_scrub.accepted_family AS tnrs_accepted_name_family, 


  		












  

    
      trunk/schemas/vegbien.sql
    
  





  9390
  9390
  
    
--


  		




  9391
  9391
  
    

  		




  9392
  9392
  
    
CREATE VIEW _plots_20_tnrs_names AS


  		




  9393
  
  
    
 SELECT taxonlabel.taxonomicname AS verbatim_name_with_author, 


  		




  
  9393
  
    
 SELECT taxonverbatim.taxonomicname AS verbatim_name_with_author, 


  		




  9394
  9394
  
    
    taxonlabel.taxonomicname AS tnrs_input_name, 


  		




  9395
  9395
  
    
    taxon_scrub."taxonomicStatus" AS tnrs_taxonomic_status, 


  		




  9396
  9396
  
    
    taxon_scrub.accepted_family AS tnrs_accepted_name_family, 


  		












Also available in:  Unified diff