root/trunk/inputs/TEX/Specimen/postprocess.sql @ 13264
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 |