root/inputs/.TNRS/tnrs_accepted/create.sql @ 6435
| 1 | 5915 | aaronmk | SELECT * |
|---|---|---|---|
| 2 | FROM tnrs |
||
| 3 | 5963 | aaronmk | WHERE 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"); |