Revision 5401
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 103 | 103 |
|
| 104 | 104 |
|
| 105 | 105 |
-- |
| 106 |
-- Name: _set_canon_taxonconcept(int(11), int(11)); Type: FUNCTION; Schema: public; Owner: - |
|
| 106 |
-- Name: _set_canon_taxonconcept(int(11), int(11), double precision); Type: FUNCTION; Schema: public; Owner: -
|
|
| 107 | 107 |
-- |
| 108 | 108 |
|
| 109 | 109 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 250 | 250 |
|
| 251 | 251 |
|
| 252 | 252 |
-- |
| 253 |
-- Name: _set_canon_taxonconcept(integer, integer); Type: FUNCTION; Schema: public; Owner: - |
|
| 253 |
-- Name: _set_canon_taxonconcept(integer, integer, double precision); Type: FUNCTION; Schema: public; Owner: -
|
|
| 254 | 254 |
-- |
| 255 | 255 |
|
| 256 |
CREATE FUNCTION _set_canon_taxonconcept(taxonconcept_id integer, canon_concept_id integer) RETURNS integer |
|
| 256 |
CREATE FUNCTION _set_canon_taxonconcept(taxonconcept_id integer, canon_concept_id integer, canon_concept_fit_fraction double precision DEFAULT NULL::double precision) RETURNS integer
|
|
| 257 | 257 |
LANGUAGE sql |
| 258 | 258 |
AS $_$ |
| 259 |
UPDATE taxonconcept SET canon_concept_id = $2 WHERE taxonconcept_id = $1 |
|
| 259 |
UPDATE taxonconcept SET |
|
| 260 |
canon_concept_id = $2 |
|
| 261 |
, canon_concept_fit_fraction = $3 |
|
| 262 |
WHERE taxonconcept_id = $1 |
|
| 260 | 263 |
RETURNING taxonconcept_id |
| 261 | 264 |
$_$; |
| 262 | 265 |
|
Also available in: Unified diff
schemas/vegbien.sql: _set_canon_taxonconcept(): Also set the canon_concept_fit_fraction