root/inputs/CTFS/StemObservation/postprocess.sql @ 11865
1 | 10418 | aaronmk | SELECT util.search_path_append('util'); |
---|---|---|---|
2 | |||
3 | SELECT mk_derived_col((:table_str, 'stemTag'), |
||
4 | 10419 | aaronmk | $$concat_ws('.', "individual_tag", "stem_subtag")$$); -- runtime: 30 s ("Time: 29390.121 ms") @starscream |
5 | 10418 | aaronmk | SELECT mk_derived_col((:table_str, 'tag'), $$"stemTag"$$); -- runtime: 25 s ("Time: 25010.752 ms") @starscream |