root/trunk/inputs/U/Specimen/postprocess.sql @ 14222
| 1 | 10575 | aaronmk | SELECT util.search_path_append('util'); |
|---|---|---|---|
| 2 | |||
| 3 | |||
| 4 | SELECT mk_derived_col((:table_str, 'county'), |
||
| 5 | 10597 | aaronmk | $$_alt("county.main", "county.alt")$$) |
| 6 | 10575 | aaronmk | ; -- runtime: 0.5 s ("Time: 610.516 ms") @starscream |
| 7 | 10592 | aaronmk | |
| 8 | SELECT mk_derived_col((:table_str, 'recordedBy'), |
||
| 9 | 10597 | aaronmk | $$_join("recordedBy_primary", "recordedBy_additional")$$) |
| 10 | 10592 | aaronmk | ; -- runtime: 2 s ("Time: 2273.582 ms") @starscream |