Revision 5510
Added by Aaron Marcuse-Kubitza over 12 years ago
| vegbien.sql | ||
|---|---|---|
| 276 | 276 |
|
| 277 | 277 |
|
| 278 | 278 |
-- |
| 279 |
-- Name: _taxonconcept_set_parent_id(integer, integer); Type: FUNCTION; Schema: public; Owner: - |
|
| 280 |
-- |
|
| 281 |
|
|
| 282 |
CREATE FUNCTION _taxonconcept_set_parent_id(taxonconcept_id integer, parent_id integer) RETURNS integer |
|
| 283 |
LANGUAGE sql |
|
| 284 |
AS $_$ |
|
| 285 |
UPDATE taxonconcept SET parent_id = $2 WHERE taxonconcept_id = $1 |
|
| 286 |
RETURNING taxonconcept_id |
|
| 287 |
$_$; |
|
| 288 |
|
|
| 289 |
|
|
| 290 |
-- |
|
| 279 | 291 |
-- Name: make_analytical_db(); Type: FUNCTION; Schema: public; Owner: - |
| 280 | 292 |
-- |
| 281 | 293 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added _taxonconcept_set_parent_id()