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