Project

General

Profile

1 5915 aaronmk
SELECT *
2
FROM tnrs
3
WHERE NOT
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");