Project

General

Profile

« Previous | Next » 

Revision 13534

schemas/public_.sql: analytical_stem_view: scrubbed_morphospecies_binomial: use new taxon_scrub.scrubbed_morphospecies_binomial

View differences:

public_.sql
6731 6731
    taxon_scrub."taxonomicStatus" AS taxonomic_status, 
6732 6732
    taxon_scrub.scrubbed_family, 
6733 6733
    taxon_scrub.scrubbed_genus, 
6734
    NULLIF(concat_ws(' '::text, COALESCE(taxon_scrub.scrubbed_genus, taxon_scrub.scrubbed_family), COALESCE(taxon_scrub.scrubbed_specific_epithet, taxon_scrub."morphospeciesSuffix")), ''::text) AS scrubbed_morphospecies_binomial, 
6734
    taxon_scrub.scrubbed_morphospecies_binomial, 
6735 6735
    taxon_scrub.scrubbed_taxon_name_no_author, 
6736 6736
    taxon_scrub.scrubbed_author, 
6737 6737
    taxonoccurrence.growthform AS "growthForm", 

Also available in: Unified diff