| 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
|
