Revision 13647
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 441 | 441 |
COMMENT ON VIEW "MatchedTaxon" IS ' |
| 442 | 442 |
to modify: |
| 443 | 443 |
SELECT "TNRS"."MatchedTaxon_modify"($$ |
| 444 |
SELECT *, __ AS accepted_morphospecies_binomial |
|
| 445 |
FROM __ |
|
| 444 |
SELECT __ |
|
| 446 | 445 |
$$); |
| 447 | 446 |
'; |
| 448 | 447 |
|
| ... | ... | |
| 677 | 676 |
COMMENT ON VIEW taxon_scrub IS ' |
| 678 | 677 |
to modify: |
| 679 | 678 |
SELECT "TNRS".taxon_scrub_modify($$ |
| 680 |
SELECT *, __ AS scrubbed_morphospecies_binomial |
|
| 681 |
FROM "TNRS"."ValidMatchedTaxon" |
|
| 682 |
LEFT JOIN "TNRS"."taxon_scrub.scrubbed_unique_taxon_name.*" USING (scrubbed_unique_taxon_name); |
|
| 679 |
SELECT __ |
|
| 683 | 680 |
$$); |
| 684 | 681 |
'; |
| 685 | 682 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 17281 | 17281 |
COMMENT ON VIEW "MatchedTaxon" IS ' |
| 17282 | 17282 |
to modify: |
| 17283 | 17283 |
SELECT "TNRS"."MatchedTaxon_modify"($$ |
| 17284 |
SELECT *, __ AS accepted_morphospecies_binomial |
|
| 17285 |
FROM __ |
|
| 17284 |
SELECT __ |
|
| 17286 | 17285 |
$$); |
| 17287 | 17286 |
'; |
| 17288 | 17287 |
|
| ... | ... | |
| 17517 | 17516 |
COMMENT ON VIEW taxon_scrub IS ' |
| 17518 | 17517 |
to modify: |
| 17519 | 17518 |
SELECT "TNRS".taxon_scrub_modify($$ |
| 17520 |
SELECT *, __ AS scrubbed_morphospecies_binomial |
|
| 17521 |
FROM "TNRS"."ValidMatchedTaxon" |
|
| 17522 |
LEFT JOIN "TNRS"."taxon_scrub.scrubbed_unique_taxon_name.*" USING (scrubbed_unique_taxon_name); |
|
| 17519 |
SELECT __ |
|
| 17523 | 17520 |
$$); |
| 17524 | 17521 |
'; |
| 17525 | 17522 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: *_modify(): removed the need to manually maintain copies of the dependent view definitions with the *s in place, because the *s are now added automatically by view_def_to_orig()