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