Revision 5188
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 131 | 131 |
|
| 132 | 132 |
|
| 133 | 133 |
-- |
| 134 |
-- Name: set_canon_taxonpath(int(11), int(11)); Type: FUNCTION; Schema: public; Owner: - |
|
| 135 |
-- |
|
| 136 |
|
|
| 137 |
|
|
| 138 |
|
|
| 139 |
|
|
| 140 |
-- |
|
| 134 | 141 |
-- Name: taxon_update_ancestors(); Type: FUNCTION; Schema: public; Owner: - |
| 135 | 142 |
-- |
| 136 | 143 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 345 | 345 |
|
| 346 | 346 |
|
| 347 | 347 |
-- |
| 348 |
-- Name: set_canon_taxonpath(integer, integer); Type: FUNCTION; Schema: public; Owner: - |
|
| 349 |
-- |
|
| 350 |
|
|
| 351 |
CREATE FUNCTION set_canon_taxonpath(taxonpath_id integer, canon_taxonpath_id integer) RETURNS integer |
|
| 352 |
LANGUAGE sql |
|
| 353 |
AS $_$ |
|
| 354 |
UPDATE taxonpath SET canon_taxonpath_id = $2 WHERE taxonpath_id = $1 |
|
| 355 |
RETURNING taxonpath_id |
|
| 356 |
$_$; |
|
| 357 |
|
|
| 358 |
|
|
| 359 |
-- |
|
| 348 | 360 |
-- Name: taxon_update_ancestors(); Type: FUNCTION; Schema: public; Owner: - |
| 349 | 361 |
-- |
| 350 | 362 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added set_canon_taxonpath() to set a taxonpath's canon_taxonpath_id after it has been created