Project

General

Profile

« Previous | Next » 

Revision 5510

schemas/vegbien.sql: Added _taxonconcept_set_parent_id()

View differences:

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