Revision 5963
Added by Aaron Marcuse-Kubitza about 12 years ago
create.sql | ||
---|---|---|
1 | 1 |
SELECT * |
2 | 2 |
FROM tnrs |
3 |
WHERE |
|
3 |
WHERE COALESCE(
|
|
4 | 4 |
"Name_submitted" = NULLIF(:schema.array_to_string(ARRAY[ |
5 | 5 |
NULLIF("Accepted_name_family", 'Unknown') |
6 | 6 |
, "Accepted_name" |
7 | 7 |
, "Accepted_name_author" |
8 | 8 |
], ' '), '') |
9 |
, false) |
|
9 | 10 |
ORDER BY "Name_submitted" |
10 | 11 |
; |
11 | 12 |
|
Also available in: Unified diff
inputs/.TNRS/tnrs_*/create.sql: Fixed bug where need to COALESCE the WHERE condition with false to ensure that a boolean value, not NULL, is negated by NOT. Otherwise, tnrs_other's query would exclude rows for which the condition returned NULL rather than false.