Revision 11619
Added by Aaron Marcuse-Kubitza about 11 years ago
| schema.sql | ||
|---|---|---|
| 76 | 76 |
|
| 77 | 77 |
|
| 78 | 78 |
-- |
| 79 |
-- Name: score_ok(double precision); Type: FUNCTION; Schema: TNRS; Owner: - |
|
| 80 |
-- |
|
| 81 |
|
|
| 82 |
CREATE FUNCTION score_ok(score double precision) RETURNS boolean |
|
| 83 |
LANGUAGE sql IMMUTABLE |
|
| 84 |
AS $_$ |
|
| 85 |
SELECT $1 >= 0.8 |
|
| 86 |
$_$; |
|
| 87 |
|
|
| 88 |
|
|
| 89 |
-- |
|
| 90 | 79 |
-- Name: tnrs_populate_fields(); Type: FUNCTION; Schema: TNRS; Owner: - |
| 91 | 80 |
-- |
| 92 | 81 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: removed no longer used score_ok(). use tnrs.Is_plant instead. (the threshold is still documented in tnrs_populate_fields().)