root/trunk/inputs/CTFS/AggregateObservation/postprocess.sql @ 14775
1 |
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 |
('diameterBreastHeight_min_cm', 'double precision') |
6 |
, ('diameterBreastHeight_max_cm', 'double precision') |
7 |
]::col_cast[]); |
8 |
|
9 |
|
10 |
SELECT mk_derived_col((:table_str, 'diameterBreastHeight_cm'), $$_avg("diameterBreastHeight_min_cm", "diameterBreastHeight_max_cm")$$); -- runtime: 0.4 s ("Time: 431.405 ms") @starscream |