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