Revision 5189
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 103 | 103 |
|
| 104 | 104 |
|
| 105 | 105 |
-- |
| 106 |
-- Name: make_analytical_db(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 106 |
-- Name: _set_canon_taxonpath(int(11), int(11)); Type: FUNCTION; Schema: public; Owner: -
|
|
| 107 | 107 |
-- |
| 108 | 108 |
|
| 109 | 109 |
|
| 110 | 110 |
|
| 111 | 111 |
|
| 112 | 112 |
-- |
| 113 |
-- Name: place_update_ancestors(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 113 |
-- Name: make_analytical_db(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 114 | 114 |
-- |
| 115 | 115 |
|
| 116 | 116 |
|
| 117 | 117 |
|
| 118 | 118 |
|
| 119 | 119 |
-- |
| 120 |
-- Name: placepath_canon_placepath_id_self_ref(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 120 |
-- Name: place_update_ancestors(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 121 | 121 |
-- |
| 122 | 122 |
|
| 123 | 123 |
|
| 124 | 124 |
|
| 125 | 125 |
|
| 126 | 126 |
-- |
| 127 |
-- Name: plantobservation_aggregateoccurrence_count_1(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 127 |
-- Name: placepath_canon_placepath_id_self_ref(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 128 | 128 |
-- |
| 129 | 129 |
|
| 130 | 130 |
|
| 131 | 131 |
|
| 132 | 132 |
|
| 133 | 133 |
-- |
| 134 |
-- Name: set_canon_taxonpath(int(11), int(11)); Type: FUNCTION; Schema: public; Owner: -
|
|
| 134 |
-- Name: plantobservation_aggregateoccurrence_count_1(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 135 | 135 |
-- |
| 136 | 136 |
|
| 137 | 137 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 249 | 249 |
|
| 250 | 250 |
|
| 251 | 251 |
-- |
| 252 |
-- Name: _set_canon_taxonpath(integer, integer); Type: FUNCTION; Schema: public; Owner: - |
|
| 253 |
-- |
|
| 254 |
|
|
| 255 |
CREATE FUNCTION _set_canon_taxonpath(taxonpath_id integer, canon_taxonpath_id integer) RETURNS integer |
|
| 256 |
LANGUAGE sql |
|
| 257 |
AS $_$ |
|
| 258 |
UPDATE taxonpath SET canon_taxonpath_id = $2 WHERE taxonpath_id = $1 |
|
| 259 |
RETURNING taxonpath_id |
|
| 260 |
$_$; |
|
| 261 |
|
|
| 262 |
|
|
| 263 |
-- |
|
| 252 | 264 |
-- Name: make_analytical_db(); Type: FUNCTION; Schema: public; Owner: - |
| 253 | 265 |
-- |
| 254 | 266 |
|
| ... | ... | |
| 345 | 357 |
|
| 346 | 358 |
|
| 347 | 359 |
-- |
| 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 |
-- |
|
| 360 | 360 |
-- Name: taxon_update_ancestors(); Type: FUNCTION; Schema: public; Owner: - |
| 361 | 361 |
-- |
| 362 | 362 |
|
Also available in: Unified diff
schemas/vegbien.sql: Renamed set_canon_taxonpath() to _set_canon_taxonpath() (adding _ prefix) so that db_xml.put() treats its arguments as arguments rather than as children with fkeys to parent