root/inputs/.TNRS/tnrs_other/create.sql @ 7113
1 | 5915 | aaronmk | SELECT * |
---|---|---|---|
2 | FROM tnrs |
||
3 | 5963 | aaronmk | WHERE NOT COALESCE( |
4 | 5915 | aaronmk | "Name_submitted" = NULLIF(:schema.array_to_string(ARRAY[ |
5 | NULLIF("Accepted_name_family", 'Unknown') |
||
6 | , "Accepted_name" |
||
7 | , "Accepted_name_author" |
||
8 | ], ' '), '') |
||
9 | 5963 | aaronmk | , false) |
10 | 5915 | aaronmk | ORDER BY "Name_submitted" |
11 | ;
|
||
12 | |||
13 | ALTER TABLE :table ADD PRIMARY KEY ("Name_submitted"); |