Revision 5963
Added by Aaron Marcuse-Kubitza about 12 years ago
| create.sql | ||
|---|---|---|
| 1 | 1 |
SELECT * |
| 2 | 2 |
FROM tnrs |
| 3 |
WHERE NOT |
|
| 3 |
WHERE NOT 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.