1
|
SELECT util.search_path_append('util');
|
2
|
|
3
|
SELECT create_if_not_exists($$ALTER TABLE $$||:table_str||$$ ADD PRIMARY KEY (specimen_id)$$);
|
4
|
|
5
|
SELECT mk_derived_col((:table_str, 'occurrenceRemarks'),
|
6
|
$$CASE WHEN "Locality_Description" IS NOT NULL THEN "Notes_Plant" END$$)
|
7
|
; -- runtime: 0.3 s ("Time: 311.190 ms") @starscream
|
8
|
|
9
|
SELECT mk_derived_col((:table_str, 'diameterBreastHeight_cm'), $$_avg("DBH_Min" , "DBH_Max" )$$); -- runtime: s ("Time: ms") @starscream
|
10
|
SELECT mk_derived_col((:table_str, 'height_m'), $$_avg("Height_Min", "Height_Max")$$); -- runtime: s ("Time: ms") @starscream
|