Revision 13632
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 138 | 138 |
|
| 139 | 139 |
|
| 140 | 140 |
-- |
| 141 |
-- Name: taxon_name_is_safe(text); Type: FUNCTION; Schema: TNRS; Owner: - |
|
| 142 |
-- |
|
| 143 |
|
|
| 144 |
CREATE FUNCTION taxon_name_is_safe(taxon_name text) RETURNS boolean |
|
| 145 |
LANGUAGE sql IMMUTABLE |
|
| 146 |
AS $_$ |
|
| 147 |
SELECT $1 != ANY("TNRS".unsafe_taxon_names())
|
|
| 148 |
$_$; |
|
| 149 |
|
|
| 150 |
|
|
| 151 |
-- |
|
| 141 | 152 |
-- Name: taxon_scrub_modify(text); Type: FUNCTION; Schema: TNRS; Owner: - |
| 142 | 153 |
-- |
| 143 | 154 |
|
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 13213 | 13213 |
|
| 13214 | 13214 |
|
| 13215 | 13215 |
-- |
| 13216 |
-- Name: taxon_name_is_safe(varchar(255)); Type: FUNCTION; Schema: TNRS; Owner: - |
|
| 13217 |
-- |
|
| 13218 |
|
|
| 13219 |
|
|
| 13220 |
|
|
| 13221 |
|
|
| 13222 |
-- |
|
| 13216 | 13223 |
-- Name: taxon_scrub_modify(varchar(255)); Type: FUNCTION; Schema: TNRS; Owner: - |
| 13217 | 13224 |
-- |
| 13218 | 13225 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 16928 | 16928 |
|
| 16929 | 16929 |
|
| 16930 | 16930 |
-- |
| 16931 |
-- Name: taxon_name_is_safe(text); Type: FUNCTION; Schema: TNRS; Owner: - |
|
| 16932 |
-- |
|
| 16933 |
|
|
| 16934 |
CREATE FUNCTION taxon_name_is_safe(taxon_name text) RETURNS boolean |
|
| 16935 |
LANGUAGE sql IMMUTABLE |
|
| 16936 |
AS $_$ |
|
| 16937 |
SELECT $1 != ANY("TNRS".unsafe_taxon_names())
|
|
| 16938 |
$_$; |
|
| 16939 |
|
|
| 16940 |
|
|
| 16941 |
-- |
|
| 16931 | 16942 |
-- Name: taxon_scrub_modify(text); Type: FUNCTION; Schema: TNRS; Owner: - |
| 16932 | 16943 |
-- |
| 16933 | 16944 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: added taxon_name_is_safe()