root/inputs/NY/Ecatalog_all/postprocess.sql @ 10560
| 1 |
SELECT util.search_path_append('util'); |
|---|---|
| 2 |
|
| 3 |
|
| 4 |
SELECT mk_derived_col((:table_str, 'locality'), |
| 5 |
$$_join("Locality", _label('substrate', "Substrate"), _label('vegetation', "Vegetation"))$$) |
| 6 |
; -- runtime: 45 s ("Time: 47353.897 ms") @starscream |
| 7 |
|
| 8 |
SELECT mk_derived_col((:table_str, 'occurrenceRemarks'), |
| 9 |
$$_join("Notes", "PlantFungDescription")$$) |
| 10 |
; -- runtime: 45 s ("Time: 44831.053 ms") @starscream |