Revision 14254
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 205 | 205 |
|
| 206 | 206 |
|
| 207 | 207 |
-- |
| 208 |
-- Name: FUNCTION taxon_match__fill_derived(); Type: COMMENT; Schema: TNRS; Owner: - |
|
| 209 |
-- |
|
| 210 |
|
|
| 211 |
COMMENT ON FUNCTION taxon_match__fill_derived() IS ' |
|
| 212 |
autogenerated, do not edit |
|
| 213 |
|
|
| 214 |
to regenerate: |
|
| 215 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
|
| 216 |
'; |
|
| 217 |
|
|
| 218 |
|
|
| 219 |
-- |
|
| 208 | 220 |
-- Name: taxon_match__match_num__fill(); Type: FUNCTION; Schema: TNRS; Owner: - |
| 209 | 221 |
-- |
| 210 | 222 |
|
| ... | ... | |
| 352 | 364 |
|
| 353 | 365 |
|
| 354 | 366 |
-- |
| 367 |
-- Name: COLUMN taxon_match."__accepted_{genus,specific_epithet}"; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 368 |
-- |
|
| 369 |
|
|
| 370 |
COMMENT ON COLUMN taxon_match."__accepted_{genus,specific_epithet}" IS '
|
|
| 371 |
derived column; = regexp_split_to_array("*Accepted_name_species", '' ''::text)
|
|
| 372 |
|
|
| 373 |
to modify: |
|
| 374 |
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''__accepted_{genus,specific_epithet}'')::util.col, $$regexp_split_to_array("*Accepted_name_species", '' ''::text)$$)::util.derived_col_def);
|
|
| 375 |
'; |
|
| 376 |
|
|
| 377 |
|
|
| 378 |
-- |
|
| 355 | 379 |
-- Name: taxon_best_match; Type: VIEW; Schema: TNRS; Owner: - |
| 356 | 380 |
-- |
| 357 | 381 |
|
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 15355 | 15355 |
|
| 15356 | 15356 |
|
| 15357 | 15357 |
-- |
| 15358 |
-- Name: FUNCTION taxon_match__fill_derived(); Type: COMMENT; Schema: TNRS; Owner: - |
|
| 15359 |
-- |
|
| 15360 |
|
|
| 15361 |
|
|
| 15362 |
|
|
| 15363 |
|
|
| 15364 |
-- |
|
| 15358 | 15365 |
-- Name: taxon_match__match_num__fill(); Type: FUNCTION; Schema: TNRS; Owner: - |
| 15359 | 15366 |
-- |
| 15360 | 15367 |
|
| ... | ... | |
| 15468 | 15475 |
|
| 15469 | 15476 |
|
| 15470 | 15477 |
-- |
| 15478 |
-- Name: COLUMN taxon_match.`__accepted_{genus,specific_epithet}`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15479 |
-- |
|
| 15480 |
|
|
| 15481 |
|
|
| 15482 |
|
|
| 15483 |
|
|
| 15484 |
-- |
|
| 15471 | 15485 |
-- Name: taxon_best_match; Type: VIEW; Schema: TNRS; Owner: - |
| 15472 | 15486 |
-- |
| 15473 | 15487 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 19275 | 19275 |
|
| 19276 | 19276 |
|
| 19277 | 19277 |
-- |
| 19278 |
-- Name: FUNCTION taxon_match__fill_derived(); Type: COMMENT; Schema: TNRS; Owner: - |
|
| 19279 |
-- |
|
| 19280 |
|
|
| 19281 |
COMMENT ON FUNCTION taxon_match__fill_derived() IS ' |
|
| 19282 |
autogenerated, do not edit |
|
| 19283 |
|
|
| 19284 |
to regenerate: |
|
| 19285 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
|
| 19286 |
'; |
|
| 19287 |
|
|
| 19288 |
|
|
| 19289 |
-- |
|
| 19278 | 19290 |
-- Name: taxon_match__match_num__fill(); Type: FUNCTION; Schema: TNRS; Owner: - |
| 19279 | 19291 |
-- |
| 19280 | 19292 |
|
| ... | ... | |
| 19464 | 19476 |
|
| 19465 | 19477 |
|
| 19466 | 19478 |
-- |
| 19479 |
-- Name: COLUMN taxon_match."__accepted_{genus,specific_epithet}"; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 19480 |
-- |
|
| 19481 |
|
|
| 19482 |
COMMENT ON COLUMN taxon_match."__accepted_{genus,specific_epithet}" IS '
|
|
| 19483 |
derived column; = regexp_split_to_array("*Accepted_name_species", '' ''::text)
|
|
| 19484 |
|
|
| 19485 |
to modify: |
|
| 19486 |
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''__accepted_{genus,specific_epithet}'')::util.col, $$regexp_split_to_array("*Accepted_name_species", '' ''::text)$$)::util.derived_col_def);
|
|
| 19487 |
'; |
|
| 19488 |
|
|
| 19489 |
|
|
| 19490 |
-- |
|
| 19467 | 19491 |
-- Name: taxon_best_match; Type: VIEW; Schema: TNRS; Owner: - |
| 19468 | 19492 |
-- |
| 19469 | 19493 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: taxon_match: ran derived_cols_update()