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