Revision 7139
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/.TNRS/schema.sql | ||
|---|---|---|
| 57 | 57 |
$BODY$ |
| 58 | 58 |
BEGIN |
| 59 | 59 |
new."Accepted_scientific_name" = NULLIF(array_to_string(ARRAY[ |
| 60 |
NULLIF(new."Accepted_name_family", 'Unknown')
|
|
| 60 |
NULLIF(NULLIF(new."Accepted_name_family", 'Unknown'), new."Accepted_name")
|
|
| 61 | 61 |
, new."Accepted_name" |
| 62 | 62 |
, new."Accepted_name_author" |
| 63 | 63 |
], ' '), ''); |
Also available in: Unified diff
inputs/.TNRS/schema.sql: tnrs_populate_accepted_scientific_name(): Fixed bug where Accepted_name_family shouldn't be prefixed to Accepted_name if Accepted_name is itself the family, to avoid duplicating the family in the Accepted_scientific_name