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