Revision 5789
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 138 | 138 |
|
| 139 | 139 |
|
| 140 | 140 |
-- |
| 141 |
-- Name: _taxon_family_require_std(text); Type: FUNCTION; Schema: public; Owner: - |
|
| 142 |
-- |
|
| 143 |
|
|
| 144 |
|
|
| 145 |
|
|
| 146 |
|
|
| 147 |
-- |
|
| 141 | 148 |
-- Name: _taxonlabel_set_matched_label_id(int(11), int(11), double precision); Type: FUNCTION; Schema: public; Owner: - |
| 142 | 149 |
-- |
| 143 | 150 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 312 | 312 |
|
| 313 | 313 |
|
| 314 | 314 |
-- |
| 315 |
-- Name: _taxon_family_require_std(text); Type: FUNCTION; Schema: public; Owner: - |
|
| 316 |
-- |
|
| 317 |
|
|
| 318 |
CREATE FUNCTION _taxon_family_require_std(family text) RETURNS text |
|
| 319 |
LANGUAGE sql IMMUTABLE STRICT |
|
| 320 |
AS $_$ |
|
| 321 |
SELECT (CASE WHEN $1 LIKE '%aceae' THEN $1 ELSE NULL END) |
|
| 322 |
$_$; |
|
| 323 |
|
|
| 324 |
|
|
| 325 |
-- |
|
| 315 | 326 |
-- Name: _taxonlabel_set_matched_label_id(integer, integer, double precision); Type: FUNCTION; Schema: public; Owner: - |
| 316 | 327 |
-- |
| 317 | 328 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added _taxon_family_require_std()