Revision 13852
Added by Aaron Marcuse-Kubitza over 10 years ago
| schema.sql | ||
|---|---|---|
| 99 | 99 |
CREATE FUNCTION taxon_name_is_safe(taxon_name text) RETURNS boolean |
| 100 | 100 |
LANGUAGE sql IMMUTABLE |
| 101 | 101 |
AS $_$ |
| 102 |
SELECT $1 != ANY("TNRS".unsafe_taxon_names())
|
|
| 102 |
SELECT NOT ($1 = ANY("TNRS".unsafe_taxon_names()))
|
|
| 103 | 103 |
$_$; |
| 104 | 104 |
|
| 105 | 105 |
|
Also available in: Unified diff
bugfix: inputs/.TNRS/schema.sql: taxon_name_is_safe(): need to use `NOT (_ = ANY()) instead of ` != ANY`, because the != operator is applied to each element