Revision 10614
Added by Aaron Marcuse-Kubitza almost 11 years ago
| inputs/UNCC/Specimen/postprocess.sql | ||
|---|---|---|
| 6 | 6 |
fruit => *fruit, |
| 7 | 7 |
$$::hstore); |
| 8 | 8 |
|
| 9 |
SELECT create_if_not_exists($$CREATE INDEX "Specimen.infrarank" ON $$||:table_str||$$ ("infrarank")$$); -- runtime: 0.1 s ("Time: 135.984 ms") @starscream
|
|
| 9 | 10 |
|
| 11 |
-- remove mismapped values |
|
| 12 |
UPDATE :table SET infrarank = NULL WHERE infrarank = 'L.'; -- runtime: ~0 ("Time: 2.370 ms") @starscream
|
|
| 13 |
|
|
| 14 |
|
|
| 10 | 15 |
SELECT mk_derived_col((:table_str, 'specimenDonorInstitution'), |
| 11 | 16 |
-- UNCCD likely = UNCC database |
| 12 | 17 |
$$_map('UNCCD=>UNCC, *=>*', "herbarium")$$)
|
Also available in: Unified diff
inputs/UNCC/Specimen/postprocess.sql: infrarank: remove mismapped values "L." (belong in authors, and are already there)