Project

General

Profile

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