SELECT util.search_path_append('util');


SELECT mk_derived_col((:table_str, 'dateCollected'),
$$_alt("EXACT DATE", "GENERAL DATE")$$)
; -- runtime: 0.3 s ("Time: 283.170 ms") @starscream

SELECT mk_derived_col((:table_str, 'recordedBy__primary'),
$$_join_words("COLLECTOR 1 FIRST NAME", "COLLECTOR 1 LAST NAME")$$)
; -- runtime: 0.2 s ("Time: 154.234 ms") @starscream

SELECT mk_derived_col((:table_str, 'recordedBy__additional__1'),
$$_join_words("COLLECTOR 2 FIRST NAME", "COLLECTOR 2 LAST NAME")$$)
; -- runtime: 0.1 s ("Time: 135.107 ms") @starscream

SELECT mk_derived_col((:table_str, 'recordedBy__additional__2'),
$$_join_words("COLLECTOR 3 FIRST NAME", "COLLECTOR 3 LAST NAME")$$)
; -- runtime: 0.1 s ("Time: 133.670 ms") @starscream

SELECT mk_derived_col((:table_str, 'recordedBy__additional__3'),
$$_join_words("COLLECTOR 4 FIRST NAME", "COLLECTOR 4 LAST NAME")$$)
; -- runtime: 0.1 s ("Time: 132.596 ms") @starscream

SELECT mk_derived_col((:table_str, 'recordedBy__additional__4'),
$$_join_words("COLLECTOR 5 FIRST NAME", "COLLECTOR 5 LAST NAME")$$)
; -- runtime: 0.1 s ("Time: 132.078 ms") @starscream

SELECT mk_derived_col((:table_str, 'recordedBy'),
$$_join("recordedBy__primary", "recordedBy__additional__1", "recordedBy__additional__2", "recordedBy__additional__3", "recordedBy__additional__4")$$)
; -- runtime: 0.1 s ("Time: 141.355 ms") @starscream
