Revision 10992
Added by Aaron Marcuse-Kubitza about 11 years ago
| postprocess.sql | ||
|---|---|---|
| 4 | 4 |
SELECT mk_derived_col((:table_str, 'aggregateOrganismObservationID'), |
| 5 | 5 |
$$_join("aggregateOrganismObservationID__taxon_presence"::text, "aggregateOrganismObservationID__individual_count"::text)$$)
|
| 6 | 6 |
; -- runtime: 15 s ("Time: 15805.876 ms") @starscream
|
| 7 |
|
|
| 8 |
|
|
| 9 |
SELECT create_if_not_exists($$ALTER TABLE $$||:table_str||$$ ADD PRIMARY KEY ("aggregateOrganismObservationID")$$); -- runtime: 20 s ("Time: 20194.932 ms") @starscream
|
|
Also available in: Unified diff
inputs/VegBank/stemcount_/postprocess.sql: added primary key. note that the inserted row count changes, most likely because the rows are now in sorted order.