new.matched_has_accepted = NULL;

	new."Accepted_family__@TNRS__@vegpath.org" = NULL;

	new."Accepted_species[_binomial]__@TNRS__@vegpath.org" = NULL;

	new."[accepted_]genus__@DwC__@vegpath.org" = NULL;

	new."[accepted_]specificEpithet__@DwC__@vegpath.org" = NULL;

	new."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" = NULL;

    ELSE NULL::text

END) FROM (SELECT new.*) new);

	new."Accepted_species[_binomial]__@TNRS__@vegpath.org" = (SELECT rtrim("*Accepted_name_species", ' '::text) FROM (SELECT new.*) new);

CASE

    WHEN ("*Accepted_name_rank" = 'genus'::text) THEN "*Accepted_name"

    ELSE NULL::text

END) FROM (SELECT new.*) new);

	new."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" = (SELECT CASE

    WHEN ("*Accepted_name_rank" = 'family'::text) THEN concat_ws(' '::text, "Accepted_family__@TNRS__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")

    WHEN ("*Accepted_name_rank" = 'genus'::text) THEN concat_ws(' '::text, "[accepted_]genus__@DwC__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")

    matched_has_accepted boolean,

    "Accepted_family__@TNRS__@vegpath.org" text,

    "Accepted_species[_binomial]__@TNRS__@vegpath.org" text,

    "[accepted_]genus__@DwC__@vegpath.org" text,

    "[accepted_]specificEpithet__@DwC__@vegpath.org" text,

    "[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" text,

END)))),

    CONSTRAINT "Accepted_species[_binomial]__@TNRS__@vegpath.org" CHECK ((NOT ("Accepted_species[_binomial]__@TNRS__@vegpath.org" IS DISTINCT FROM rtrim("*Accepted_name_species", ' '::text)))),

    CONSTRAINT "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" CHECK ((NOT ("[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" IS DISTINCT FROM "__accepted_infraspecific_{rank,epithet}"[1]))),

CASE

    WHEN ("*Accepted_name_rank" = 'genus'::text) THEN "*Accepted_name"

    ELSE NULL::text

    ELSE "Accepted_species[_binomial]__@TNRS__@vegpath.org"

END))),

    CONSTRAINT "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" IS DISTINCT FROM ("*Accepted_name" || COALESCE((' '::text || "*Accepted_name_author"), ''::text))))),

    CONSTRAINT "[matched_]scientificName[_with_author]__@DwC__@vegpath.org" CHECK ((NOT ("[matched_]scientificName[_with_author]__@DwC__@vegpath.org" IS DISTINCT FROM ("matched~Name[_no_author]___@TNRS__@vegpath.org" || COALESCE((' '::text || "*Name_matched_author"), ''::text))))),

    CONSTRAINT "[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org" CHECK ((NOT ("[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org" IS DISTINCT FROM (("*Genus_matched" || ' '::text) || "*Specific_epithet_matched")))),

    CONSTRAINT "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org" CHECK ((NOT ("[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org" IS DISTINCT FROM "*Unmatched_terms"))),

    CONSTRAINT "[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" CHECK ((NOT ("[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" IS DISTINCT FROM map_taxonomic_status("*Taxonomic_status", "*Accepted_name")))),

    CONSTRAINT __accepted_infraspecific_label CHECK ((NOT (__accepted_infraspecific_label IS DISTINCT FROM ltrim(NULLIF(remove_prefix("Accepted_species[_binomial]__@TNRS__@vegpath.org", "*Accepted_name", require := true, case_sensitive := false), ''::text), ' '::text)))),

    CONSTRAINT "__accepted_infraspecific_{rank,epithet}" CHECK ((NOT ("__accepted_infraspecific_{rank,epithet}" IS DISTINCT FROM regexp_split_to_array(__accepted_infraspecific_label, ' '::text)))),

    CONSTRAINT matched_has_accepted CHECK ((NOT (matched_has_accepted IS DISTINCT FROM ("*Accepted_name" IS NOT NULL)))),

    CONSTRAINT "matched~Name[_no_author]___@TNRS__@vegpath.org" CHECK ((NOT ("matched~Name[_no_author]___@TNRS__@vegpath.org" IS DISTINCT FROM NULLIF("*Name_matched", 'No suitable matches found.'::text))))

);

--

--

= regexp_split_to_array("*Accepted_name", '' ''::text)

derived column

to modify expr:

SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);

to rename:

--

COMMENT ON COLUMN taxon_match."[accepted_]genus__@DwC__@vegpath.org" IS '

CASE

    WHEN ("*Accepted_name_rank" = ''genus''::text) THEN "*Accepted_name"

    ELSE NULL::text

derived column

to modify expr:

CASE

    WHEN ("*Accepted_name_rank" = ''genus''::text) THEN "*Accepted_name"

    ELSE NULL::text

--

COMMENT ON COLUMN taxon_match."[accepted_]specificEpithet__@DwC__@vegpath.org" IS '

derived column

to modify expr:

SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);

to rename:

    taxon_match.matched_has_accepted,

    taxon_match."Accepted_family__@TNRS__@vegpath.org",

    taxon_match."Accepted_species[_binomial]__@TNRS__@vegpath.org",

    taxon_match."[accepted_]genus__@DwC__@vegpath.org",

    taxon_match."[accepted_]specificEpithet__@DwC__@vegpath.org",

    taxon_match."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",