Study2025/_Infra/scripts/CalcResult20240311.sql

do $$
declare
	par_input_params public.input_params_type;
	par_results public.calc_result_type[];
	rec record;
begin

	par_input_params.height := 430;
	par_input_params.temperature := 15;
	par_input_params.pressure := 780;
	par_input_params.wind_direction := 2;
	par_input_params.wind_speed := 10;
	par_input_params.bullet_demolition_range := 0;

	
	call public.sp_calc_corrections(par_input_params => par_input_params, par_measurement_type_id => 2,
		par_results => par_results);

	raise notice '| measurement_type_id  | height | deltapressure | deltatemperature | deviationtemperature | deviationwind | deviationwinddirection |';
	raise notice '|----------------------|--------|---------------|------------------|----------------------|---------------|------------------------|';

	foreach rec in ARRAY par_results LOOP
		raise notice '| % | % | % | % | % | % | % |' ,
			lpad(rec.measurement_type_id::text, 20, ' '), 
			lpad(rec.height::text, 6, ' '), 
			lpad(rec.deltapressure::text, 13, ' '), 
			lpad(rec.deltatemperature::text, 16, ' '), 
			lpad(rec.deviationtemperature::text, 20, ' '),
			lpad(rec.deviationwind::text, 13, ' '),
			lpad(rec.deviationwinddirection::text, 22, ' ');
	end loop;
	
end $$