Revision 7158
Added by Aaron Marcuse-Kubitza almost 12 years ago
inputs/.TNRS/schema.sql | ||
---|---|---|
140 | 140 |
CASE |
141 | 141 |
WHEN tnrs_accepted.* IS NOT NULL THEN tnrs_accepted.* |
142 | 142 |
ELSE tnrs.* |
143 |
END)."Infraspecific_epithet_2_matched" AS "Infraspecific_epithet_2_matched", tnrs."Infraspecific_epithet_2_score", ( |
|
143 |
END)."Infraspecific_epithet_2_matched" AS "Infraspecific_epithet_2_matched", tnrs."Infraspecific_epithet_2_score", tnrs."Annotations" AS "Annotations", tnrs."Unmatched_terms" AS "Unmatched_terms", (
|
|
144 | 144 |
CASE |
145 | 145 |
WHEN tnrs_accepted.* IS NOT NULL THEN tnrs_accepted.* |
146 | 146 |
ELSE tnrs.* |
147 |
END)."Annotations" AS "Annotations", tnrs."Unmatched_terms" AS "Unmatched_terms", ( |
|
148 |
CASE |
|
149 |
WHEN tnrs_accepted.* IS NOT NULL THEN tnrs_accepted.* |
|
150 |
ELSE tnrs.* |
|
151 | 147 |
END)."Taxonomic_status" AS "Taxonomic_status", ( |
152 | 148 |
CASE |
153 | 149 |
WHEN tnrs_accepted.* IS NOT NULL THEN tnrs_accepted.* |
Also available in: Unified diff
inputs/.TNRS/schema.sql: tnrs_canon: Annotations: Always use value from the matched name, because the accepted name does not have this