Revision 12758
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/inputs/VegBank/plot/postprocess.sql | ||
|---|---|---|
| 7 | 7 |
|
| 8 | 8 |
-- CVS |
| 9 | 9 |
DELETE FROM :table |
| 10 |
WHERE "locationName" IN (SELECT "authorPlotCode" FROM "CVS".plot)
|
|
| 10 |
WHERE "locationName" IN (SELECT "locationName" FROM "CVS".plot_)
|
|
| 11 | 11 |
-- removes 2323 of 7079 CVS plots (75340 - 73017) |
| 12 | 12 |
; -- runtime: 1 min ("69478.847 ms") @starscream
|
| 13 | 13 |
|
Also available in: Unified diff
bugfix: inputs/VegBank/plot/postprocess.sql: use CVS.plot_ instead because that has the renamed staging table columns, and is compatible with auto-renaming of the SQL script columns