Revision 5799
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/.TNRS/schema.sql | ||
|---|---|---|
| 58 | 58 |
CREATE INDEX tnrs_accepted_names |
| 59 | 59 |
ON tnrs |
| 60 | 60 |
USING btree |
| 61 |
((NOT "Name_submitted" = NULLIF(:schema.array_to_string(ARRAY["Accepted_name", "Accepted_name_author"], ' '::text), ''::text)) , "Name_submitted" ); |
|
| 61 |
((NOT "Name_submitted" = NULLIF(:schema.array_to_string(ARRAY[NULLIF("Accepted_name_family", 'Unknown'::text), "Accepted_name", "Accepted_name_author"], ' '::text), ''::text)) , "Name_submitted" );
|
|
| 62 | 62 |
ALTER TABLE tnrs CLUSTER ON tnrs_accepted_names; |
Also available in: Unified diff
inputs/.TNRS/schema.sql: tnrs_accepted_names: Prepend the Accepted_name_family to the taxonomic name that will be submitted back to TNRS for parsing, because TNRS input names now always include the family when it's provided