Project

General

Profile

1 10393 aaronmk
SELECT util.search_path_append('util');
2
3
-- runtime: 0.3 s ("Time: 256.926 ms") @starscream
4
SELECT set_col_types(:table_str, ARRAY[
5 10419 aaronmk
  ('diameterBreastHeight_min_cm', 'double precision')
6
, ('diameterBreastHeight_max_cm', 'double precision')
7 10393 aaronmk
]::col_cast[]);
8
9
10 10419 aaronmk
SELECT mk_derived_col((:table_str, 'diameterBreastHeight_cm'), $$_avg("diameterBreastHeight_min_cm", "diameterBreastHeight_max_cm")$$); -- runtime: 0.4 s ("Time: 431.405 ms") @starscream