Revision 11709
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/.TNRS/schema.sql | ||
|---|---|---|
| 77 | 77 |
|
| 78 | 78 |
|
| 79 | 79 |
-- |
| 80 |
-- Name: map_taxonomic_status(text, text); Type: FUNCTION; Schema: TNRS; Owner: - |
|
| 81 |
-- |
|
| 82 |
|
|
| 83 |
CREATE FUNCTION map_taxonomic_status(taxonomic_status_verbatim text, scrubbed_unique_taxon_name text) RETURNS text |
|
| 84 |
LANGUAGE sql IMMUTABLE |
|
| 85 |
AS $_$ |
|
| 86 |
SELECT CASE WHEN $2 IS NOT NULL THEN 'accepted' ELSE lower($1) END |
|
| 87 |
$_$; |
|
| 88 |
|
|
| 89 |
|
|
| 90 |
-- |
|
| 80 | 91 |
-- Name: tnrs_populate_fields(); Type: FUNCTION; Schema: TNRS; Owner: - |
| 81 | 92 |
-- |
| 82 | 93 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: added map_taxonomic_status()