Revision 9859
Added by Aaron Marcuse-Kubitza about 11 years ago
| vegbien.sql | ||
|---|---|---|
| 406 | 406 |
|
| 407 | 407 |
|
| 408 | 408 |
-- |
| 409 |
-- Name: _filter_genus(text); Type: FUNCTION; Schema: public; Owner: - |
|
| 410 |
-- |
|
| 411 |
|
|
| 412 |
CREATE FUNCTION _filter_genus(value text) RETURNS text |
|
| 413 |
LANGUAGE sql IMMUTABLE STRICT |
|
| 414 |
AS $_$ |
|
| 415 |
SELECT (CASE WHEN $1 ~ '\d' THEN NULL ELSE $1 END) |
|
| 416 |
$_$; |
|
| 417 |
|
|
| 418 |
|
|
| 419 |
-- |
|
| 409 | 420 |
-- Name: _fraction_to_percent(double precision); Type: FUNCTION; Schema: public; Owner: - |
| 410 | 421 |
-- |
| 411 | 422 |
|
Also available in: Unified diff
schemas/vegbien.sql: added _filter_genus()