Project

General

Profile

« Previous | Next » 

Revision 14428

Added by Aaron Marcuse-Kubitza over 10 years ago

schemas/public_.sql: tnrs_input_name: use taxon_best_match now that it's equivalent to MatchedTaxon

View differences:

trunk/schemas/public_.sql
11638 11638 
CREATE VIEW tnrs_input_name AS
11639 11639 
 SELECT DISTINCT taxonlabel.taxonomicname
11640 11640 
   FROM (taxonlabel
11641 
   LEFT JOIN "TNRS"."MatchedTaxon" ON (("MatchedTaxon"."*Name_submitted" = taxonlabel.taxonomicname)))
11642 
  WHERE (((taxonlabel.taxonomicname IS NOT NULL) AND ("MatchedTaxon"."*Name_submitted" IS NULL)) AND "TNRS".taxon_name_is_safe(taxonlabel.taxonomicname))
11641 
   LEFT JOIN "TNRS".taxon_best_match ON ((taxon_best_match."*Name_submitted" = taxonlabel.taxonomicname)))
11642 
  WHERE (((taxonlabel.taxonomicname IS NOT NULL) AND (taxon_best_match."*Name_submitted" IS NULL)) AND "TNRS".taxon_name_is_safe(taxonlabel.taxonomicname))
11643 11643 
  ORDER BY taxonlabel.taxonomicname;
11644 11644 

  		




  11645
  11645
  
    

  		












  

    
      trunk/schemas/vegbien.sql
    
  





  11638
  11638
  
    
CREATE VIEW tnrs_input_name AS


  		




  11639
  11639
  
    
 SELECT DISTINCT taxonlabel.taxonomicname


  		




  11640
  11640
  
    
   FROM (taxonlabel


  		




  11641
  
  
    
   LEFT JOIN "TNRS"."MatchedTaxon" ON (("MatchedTaxon"."*Name_submitted" = taxonlabel.taxonomicname)))


  		




  11642
  
  
    
  WHERE (((taxonlabel.taxonomicname IS NOT NULL) AND ("MatchedTaxon"."*Name_submitted" IS NULL)) AND "TNRS".taxon_name_is_safe(taxonlabel.taxonomicname))


  		




  
  11641
  
    
   LEFT JOIN "TNRS".taxon_best_match ON ((taxon_best_match."*Name_submitted" = taxonlabel.taxonomicname)))


  		




  
  11642
  
    
  WHERE (((taxonlabel.taxonomicname IS NOT NULL) AND (taxon_best_match."*Name_submitted" IS NULL)) AND "TNRS".taxon_name_is_safe(taxonlabel.taxonomicname))


  		




  11643
  11643
  
    
  ORDER BY taxonlabel.taxonomicname;


  		




  11644
  11644
  
    

  		




  11645
  11645
  
    

  		












Also available in:  Unified diff