SELECT s."*Name_matched.batch", 

    s."concatenatedScientificName", 

    s."matchedTaxonName", 

    s."matchedTaxonRank", 

    s."*Name_matched.Name_score", 

    s."matchedScientificNameAuthorship", 

    s."matchedScientificNameID", 

    s."*Name_matched.Author_score", 

    s."matchedFamilyConfidence_fraction", 

    s."matchedFamily", 

    s."matchedGenus", 

    s."matchedGenusConfidence_fraction", 

    s."matchedSpecificEpithet", 

    s."matchedSpeciesConfidence_fraction", 

    s."matchedInfraspecificEpithet", 

    s."*Name_matched.Infraspecific_epithet_score", 

    s."identificationQualifier", 

    s."morphospeciesSuffix", 

    s."taxonomicStatus", 

    s.accepted_taxon_name_no_author, 

    s.accepted_author, 

    s.accepted_taxon_rank, 

    s."acceptedScientificNameID", 

    s.accepted_species_binomial, 

    s.accepted_family, 

    s."*Name_matched.Selected", 

    s."*Name_matched.Source", 

    s."*Name_matched.Warnings", 

    s."*Name_matched.Accepted_name_lsid", 

    s.taxon_scrub__is_valid_match, 

    s.scrubbed_unique_taxon_name, 

        CASE

            WHEN (s.accepted_taxon_rank = 'family'::text) THEN concat_ws(' '::text, s.accepted_family, s."morphospeciesSuffix")

            WHEN (s.accepted_taxon_rank = 'genus'::text) THEN concat_ws(' '::text, s.accepted_taxon_name_no_author, s."morphospeciesSuffix")

            ELSE s.accepted_species_binomial

        END AS accepted_morphospecies_binomial

   FROM ( SELECT tnrs.batch AS "*Name_matched.batch", 

            tnrs."Name_submitted" AS "concatenatedScientificName", 

            tnrs."Name_matched" AS "matchedTaxonName", 

            tnrs."Name_matched_rank" AS "matchedTaxonRank", 

            tnrs."Name_score" AS "*Name_matched.Name_score", 

            tnrs."Name_matched_author" AS "matchedScientificNameAuthorship", 

            tnrs."Name_matched_url" AS "matchedScientificNameID", 

            tnrs."Author_score" AS "*Name_matched.Author_score", 

            tnrs."Family_score" AS "matchedFamilyConfidence_fraction", 

            COALESCE(tnrs."Name_matched_accepted_family", tnrs."Accepted_name_family") AS "matchedFamily", 

            tnrs."Genus_matched" AS "matchedGenus", 

            tnrs."Genus_score" AS "matchedGenusConfidence_fraction", 

            tnrs."Specific_epithet_matched" AS "matchedSpecificEpithet", 

            tnrs."Specific_epithet_score" AS "matchedSpeciesConfidence_fraction", 

            tnrs."Infraspecific_epithet_matched" AS "matchedInfraspecificEpithet", 

            tnrs."Infraspecific_epithet_score" AS "*Name_matched.Infraspecific_epithet_score", 

            tnrs."Annotations" AS "identificationQualifier", 

            tnrs."Unmatched_terms" AS "morphospeciesSuffix", 

            tnrs."Taxonomic_status" AS "taxonomicStatus", 

            tnrs."Accepted_name" AS accepted_taxon_name_no_author, 

            tnrs."Accepted_name_author" AS accepted_author, 

            tnrs."Accepted_name_rank" AS accepted_taxon_rank, 

            tnrs."Accepted_name_url" AS "acceptedScientificNameID", 

            tnrs."Accepted_name_species" AS accepted_species_binomial, 

            tnrs."Accepted_name_family" AS accepted_family, 

            tnrs."Selected" AS "*Name_matched.Selected", 

            tnrs."Source" AS "*Name_matched.Source", 

            tnrs."Warnings" AS "*Name_matched.Warnings", 

            tnrs."Accepted_name_lsid" AS "*Name_matched.Accepted_name_lsid", 

            tnrs.is_valid_match AS taxon_scrub__is_valid_match, 

            tnrs.scrubbed_unique_taxon_name

           FROM tnrs) s;

-- Name: VIEW "MatchedTaxon"; Type: COMMENT; Schema: TNRS; Owner: -

--

COMMENT ON VIEW "MatchedTaxon" IS '

to update, use `*, ... AS accepted_morphospecies_binomial` as the column list

';

--

    "MatchedTaxon".scrubbed_unique_taxon_name, 

    "MatchedTaxon".accepted_morphospecies_binomial

    "ValidMatchedTaxon".accepted_morphospecies_binomial,