Revision 5510
Added by Aaron Marcuse-Kubitza about 12 years ago
schemas/vegbien.my.sql | ||
---|---|---|
117 | 117 |
|
118 | 118 |
|
119 | 119 |
-- |
120 |
-- Name: _taxonconcept_set_parent_id(int(11), int(11)); Type: FUNCTION; Schema: public; Owner: - |
|
121 |
-- |
|
122 |
|
|
123 |
|
|
124 |
|
|
125 |
|
|
126 |
-- |
|
120 | 127 |
-- Name: make_analytical_db(); Type: FUNCTION; Schema: public; Owner: - |
121 | 128 |
-- |
122 | 129 |
|
schemas/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()