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