Revision 9987
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/.TNRS/schema.sql | ||
|---|---|---|
| 112 | 112 |
, new."Genus_score" |
| 113 | 113 |
, new."Specific_epithet_score" |
| 114 | 114 |
); |
| 115 |
new."Is_homonym" = family_is_homonym OR genus_is_homonym;
|
|
| 115 |
new."Is_homonym" = COALESCE(genus_is_homonym, family_is_homonym);
|
|
| 116 | 116 |
new."Is_plant" = (CASE |
| 117 | 117 |
WHEN new."Family_score" = 1 AND NOT family_is_homonym -- exact match |
| 118 | 118 |
THEN true |
Also available in: Unified diff
bugfix: inputs/.TNRS/schema.sql: tnrs_populate_fields(): Is_homonym: use the *_is_homonym flag for whichever of genus or family (in that order) is NOT NULL, rather than horizontal-ORing potentially NULL values together