Revision 11809
Added by Aaron Marcuse-Kubitza almost 11 years ago
| postprocess.sql | ||
|---|---|---|
| 12 | 12 |
genus_main = trim(genus_main, '{}') -- applies to 6 rows
|
| 13 | 13 |
WHERE genus_main LIKE '{%}' -- applies to 6 rows
|
| 14 | 14 |
; -- rerun time: 0.5 s ("492.670 ms") @starscream; runtime: 0.5 s ("543.942 ms") @starscream
|
| 15 |
|
|
| 16 |
|
|
| 17 |
SELECT mk_derived_col((:table_str, 'identifiedBy'), |
|
| 18 |
$$_join_words("identifiedBy__first", "identifiedBy__middle", "identifiedBy__last")$$)
|
|
| 19 |
; -- runtime: 15 s ("14351.532 ms") @starscream
|
|
Also available in: Unified diff
fix: inputs/CVS/taxonObservation_/create.sql: mapped identifiedBy, which involves joining to party