Revision 9859
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 186 | 186 |
|
| 187 | 187 |
|
| 188 | 188 |
-- |
| 189 |
-- Name: _filter_genus(text); Type: FUNCTION; Schema: public; Owner: - |
|
| 190 |
-- |
|
| 191 |
|
|
| 192 |
|
|
| 193 |
|
|
| 194 |
|
|
| 195 |
-- |
|
| 189 | 196 |
-- Name: _fraction_to_percent(double precision); Type: FUNCTION; Schema: public; Owner: - |
| 190 | 197 |
-- |
| 191 | 198 |
|
| schemas/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()