Revision 7597
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.sql | ||
|---|---|---|
| 590 | 590 |
CREATE FUNCTION _taxon_family_require_std(family text) RETURNS text |
| 591 | 591 |
LANGUAGE sql IMMUTABLE STRICT |
| 592 | 592 |
AS $_$ |
| 593 |
SELECT (CASE WHEN lower($1) LIKE '%aceae' THEN $1 ELSE NULL END) |
|
| 593 |
SELECT (CASE WHEN |
|
| 594 |
lower($1) LIKE '%aceae' |
|
| 595 |
OR lower($1) IN ( |
|
| 596 |
'compositae', |
|
| 597 |
'cruciferae', |
|
| 598 |
'gramineae', |
|
| 599 |
'labiatae', |
|
| 600 |
'leguminosae', |
|
| 601 |
'palmae', |
|
| 602 |
'umbelliferae' |
|
| 603 |
) |
|
| 604 |
THEN $1 ELSE NULL END) |
|
| 594 | 605 |
$_$; |
| 595 | 606 |
|
| 596 | 607 |
|
Also available in: Unified diff
schemas/vegbien.sql: _taxon_family_require_std(): Also allow non-aceae families accepted by TNRS