Revision 14303
Added by Aaron Marcuse-Kubitza over 10 years ago
| schema.sql | ||
|---|---|---|
| 309 | 309 |
END |
| 310 | 310 |
FROM (SELECT new.*) new); |
| 311 | 311 |
|
| 312 |
new."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org" = (SELECT |
|
| 313 |
"*Unmatched_terms" |
|
| 314 |
FROM (SELECT new.*) new); |
|
| 315 |
|
|
| 312 | 316 |
RETURN new; |
| 313 | 317 |
END; |
| 314 | 318 |
$$; |
| ... | ... | |
| 460 | 464 |
"[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" text, |
| 461 | 465 |
"[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org" text, |
| 462 | 466 |
"[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" text, |
| 467 |
"[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org" text, |
|
| 463 | 468 |
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]))),
|
| 464 | 469 |
CONSTRAINT "[accepted_]genus__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]genus__@DwC__@vegpath.org" IS DISTINCT FROM "__accepted_{genus,specific_epithet}"[1]))),
|
| 465 | 470 |
CONSTRAINT "[accepted_]infraspecificEpithet__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]infraspecificEpithet__@DwC__@vegpath.org" IS DISTINCT FROM "__accepted_infraspecific_{rank,epithet}"[2]))),
|
| ... | ... | |
| 467 | 472 |
CONSTRAINT "[accepted_]specificEpithet__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]specificEpithet__@DwC__@vegpath.org" IS DISTINCT FROM "__accepted_{genus,specific_epithet}"[2]))),
|
| 468 | 473 |
CONSTRAINT "[matched_]scientificName[_with_author]__@DwC__@vegpath.org" CHECK ((NOT ("[matched_]scientificName[_with_author]__@DwC__@vegpath.org" IS DISTINCT FROM ("*Name_matched" || COALESCE((' '::text || "*Name_matched_author"), ''::text))))),
|
| 469 | 474 |
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")))),
|
| 475 |
CONSTRAINT "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org" CHECK ((NOT ("[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org" IS DISTINCT FROM "*Unmatched_terms"))),
|
|
| 470 | 476 |
CONSTRAINT "[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" CHECK ((NOT ("[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" IS DISTINCT FROM
|
| 471 | 477 |
CASE |
| 472 | 478 |
WHEN matched_has_accepted THEN "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" |
| ... | ... | |
| 1034 | 1040 |
|
| 1035 | 1041 |
|
| 1036 | 1042 |
-- |
| 1043 |
-- Name: COLUMN taxon_match."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 1044 |
-- |
|
| 1045 |
|
|
| 1046 |
COMMENT ON COLUMN taxon_match."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org" IS ' |
|
| 1047 |
= "*Unmatched_terms" |
|
| 1048 |
|
|
| 1049 |
derived column |
|
| 1050 |
|
|
| 1051 |
to modify expr: |
|
| 1052 |
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org'')::util.col, $$"*Unmatched_terms"$$)::util.derived_col_def);
|
|
| 1053 |
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);
|
|
| 1054 |
|
|
| 1055 |
to rename: |
|
| 1056 |
# rename column |
|
| 1057 |
# rename CHECK constraint |
|
| 1058 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
|
| 1059 |
'; |
|
| 1060 |
|
|
| 1061 |
|
|
| 1062 |
-- |
|
| 1037 | 1063 |
-- Name: taxon_best_match; Type: VIEW; Schema: TNRS; Owner: - |
| 1038 | 1064 |
-- |
| 1039 | 1065 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: taxon_match: added derived column "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org"