Revision 10753
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/.TNRS/schema.sql | ||
|---|---|---|
| 281 | 281 |
FROM "MatchedTaxon" |
| 282 | 282 |
WHERE score_ok("matchedTaxonConfidence_fraction")
|
| 283 | 283 |
; |
| 284 |
COMMENT ON VIEW "ValidMatchedTaxon" |
|
| 285 |
IS 'to update, use * as the column list'; |
|
| 284 | 286 |
|
| 285 | 287 |
CREATE OR REPLACE VIEW "AcceptedTaxon" AS |
| 286 | 288 |
SELECT |
| ... | ... | |
| 302 | 304 |
FROM "ValidMatchedTaxon" |
| 303 | 305 |
NATURAL LEFT JOIN "AcceptedTaxon" |
| 304 | 306 |
; |
| 307 |
COMMENT ON VIEW "ScrubbedTaxon" |
|
| 308 |
IS 'to update, use * as the column list'; |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: views that use * as the column list: added comments to indicate that this is the case, so that the views can be updated in place rather than only by reinstalling the TNRS schema