root/trunk/inputs/TEX/Specimen/postprocess.sql
| 1 | 10620 | aaronmk | SELECT util.search_path_append('util'); |
|---|---|---|---|
| 2 | |||
| 3 | |||
| 4 | SELECT mk_derived_col((:table_str, 'dateCollected'), |
||
| 5 | 10625 | aaronmk | $$_alt("dateCollected__scrubbed", "dateCollected__verbatim")$$) |
| 6 | 10620 | aaronmk | ; -- runtime: 2 s ("Time: 1734.640 ms") @starscream |
| 7 | 11924 | aaronmk | |
| 8 | |||
| 9 | SELECT mk_derived_col((:table_str, 'occurrenceRemarks'), |
||
| 10 | $$_join("specimenDescription", "habitat")$$) |
||
| 11 | ; -- runtime: 1 s ("1113.080 ms") @starscream |