Revision 10992
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/VegBank/stemcount_/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
|
|
| inputs/VegBank/stemcount_/test.xml.ref | ||
|---|---|---|
| 29 | 29 |
</path> |
| 30 | 30 |
</_setDefault> |
| 31 | 31 |
</VegBIEN> |
| 32 |
Inserted 8 new rows into database |
|
| 32 |
Inserted 7 new rows into database |
|
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.