Revision 13852
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.sql | ||
|---|---|---|
| 19048 | 19048 |
CREATE FUNCTION taxon_name_is_safe(taxon_name text) RETURNS boolean |
| 19049 | 19049 |
LANGUAGE sql IMMUTABLE |
| 19050 | 19050 |
AS $_$ |
| 19051 |
SELECT $1 != ANY("TNRS".unsafe_taxon_names())
|
|
| 19051 |
SELECT NOT ($1 = ANY("TNRS".unsafe_taxon_names()))
|
|
| 19052 | 19052 |
$_$; |
| 19053 | 19053 |
|
| 19054 | 19054 |
|
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