SELECT util.search_path_append('util');


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


SELECT mk_derived_col((:table_str, 'recordedBy__primary'),
$$_join_words("recordedBy__primary__first", "recordedBy__primary__last")$$)
; -- runtime: 0.2 s ("Time: 154.234 ms") @starscream

SELECT mk_derived_col((:table_str, 'recordedBy__additional__1'),
$$_join_words("recordedBy__additional__1__first", "recordedBy__additional__1__last")$$)
; -- runtime: 0.1 s ("Time: 135.107 ms") @starscream

SELECT mk_derived_col((:table_str, 'recordedBy__additional__2'),
$$_join_words("recordedBy__additional__2__first", "recordedBy__additional__2__last")$$)
; -- runtime: 0.1 s ("Time: 133.670 ms") @starscream

SELECT mk_derived_col((:table_str, 'recordedBy__additional__3'),
$$_join_words("recordedBy__additional__3__first", "recordedBy__additional__3__last")$$)
; -- runtime: 0.1 s ("Time: 132.596 ms") @starscream

SELECT mk_derived_col((:table_str, 'recordedBy__additional__4'),
$$_join_words("recordedBy__additional__4__first", "recordedBy__additional__4__last")$$)
; -- 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


SELECT mk_derived_col((:table_str, 'identifiedBy'),
$$_join_words("identifiedBy__first", "identifiedBy__last")$$)
; -- runtime: 0.3 s ("Time: 267.310 ms") @starscream


SELECT mk_derived_col((:table_str, 'occurrenceRemarks'),
$$_join("specimenDescription", "habitat")$$)
; -- runtime: 0.2 s ("158.403 ms") @starscream