Revision 14277
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.sql | ||
|---|---|---|
| 19301 | 19301 |
"*Accepted_name" || COALESCE((' '::text || "*Accepted_name_author"), ''::text)
|
| 19302 | 19302 |
FROM (SELECT new.*) new); |
| 19303 | 19303 |
|
| 19304 |
new._matched_has_accepted = (SELECT
|
|
| 19304 |
new.matched_has_accepted = (SELECT |
|
| 19305 | 19305 |
"*Accepted_name" IS NOT NULL |
| 19306 | 19306 |
FROM (SELECT new.*) new); |
| 19307 | 19307 |
|
| ... | ... | |
| 19486 | 19486 |
"[accepted_]infraspecificEpithet__@DwC__@vegpath.org" text, |
| 19487 | 19487 |
"[matched_]scientificName[_with_author]__@DwC__@vegpath.org" text, |
| 19488 | 19488 |
"[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" text, |
| 19489 |
_matched_has_accepted boolean,
|
|
| 19489 |
matched_has_accepted boolean, |
|
| 19490 | 19490 |
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]))),
|
| 19491 | 19491 |
CONSTRAINT "[accepted_]genus__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]genus__@DwC__@vegpath.org" IS DISTINCT FROM "__accepted_{genus,specific_epithet}"[1]))),
|
| 19492 | 19492 |
CONSTRAINT "[accepted_]infraspecificEpithet__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]infraspecificEpithet__@DwC__@vegpath.org" IS DISTINCT FROM "__accepted_infraspecific_{rank,epithet}"[2]))),
|
| ... | ... | |
| 19496 | 19496 |
CONSTRAINT __accepted_infraspecific_label CHECK ((NOT (__accepted_infraspecific_label IS DISTINCT FROM ltrim(NULLIF(util.remove_prefix("*Accepted_name_species", "*Accepted_name", require := true), ''::text), ' '::text)))),
|
| 19497 | 19497 |
CONSTRAINT "__accepted_infraspecific_{rank,epithet}" CHECK ((NOT ("__accepted_infraspecific_{rank,epithet}" IS DISTINCT FROM regexp_split_to_array(__accepted_infraspecific_label, ' '::text)))),
|
| 19498 | 19498 |
CONSTRAINT "__accepted_{genus,specific_epithet}" CHECK ((NOT ("__accepted_{genus,specific_epithet}" IS DISTINCT FROM regexp_split_to_array("*Accepted_name_species", ' '::text)))),
|
| 19499 |
CONSTRAINT _matched_has_accepted CHECK ((NOT (_matched_has_accepted IS DISTINCT FROM ("*Accepted_name" IS NOT NULL))))
|
|
| 19499 |
CONSTRAINT matched_has_accepted CHECK ((NOT (matched_has_accepted IS DISTINCT FROM ("*Accepted_name" IS NOT NULL))))
|
|
| 19500 | 19500 |
); |
| 19501 | 19501 |
|
| 19502 | 19502 |
|
| ... | ... | |
| 19692 | 19692 |
|
| 19693 | 19693 |
|
| 19694 | 19694 |
-- |
| 19695 |
-- Name: COLUMN taxon_match._matched_has_accepted; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 19695 |
-- Name: COLUMN taxon_match.matched_has_accepted; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 19696 | 19696 |
-- |
| 19697 | 19697 |
|
| 19698 |
COMMENT ON COLUMN taxon_match._matched_has_accepted IS '
|
|
| 19698 |
COMMENT ON COLUMN taxon_match.matched_has_accepted IS ' |
|
| 19699 | 19699 |
derived column; = "*Accepted_name" IS NOT NULL |
| 19700 | 19700 |
|
| 19701 | 19701 |
to modify expr: |
| 19702 |
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''_matched_has_accepted'')::util.col, $$"*Accepted_name" IS NOT NULL$$)::util.derived_col_def);
|
|
| 19702 |
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''matched_has_accepted'')::util.col, $$"*Accepted_name" IS NOT NULL$$)::util.derived_col_def);
|
|
| 19703 | 19703 |
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);
|
| 19704 | 19704 |
|
| 19705 | 19705 |
to rename: |
Also available in: Unified diff
inputs/.TNRS/schema.sql: _matched_has_accepted: renamed to matched_has_accepted because the leading _ did not create vertical alignment anyway, due to different quoting syntaxes