20250214.sql 482 B

123456789101112131415161718192021
  1. do $$
  2. declare
  3. var_min_temperature numeric(8,2) default 0;
  4. var_max_temperature numeric(8,2) default 30;
  5. var_step numeric(8,2) default 0.01;
  6. var_current_temperature numeric;
  7. var_index integer;
  8. begin
  9. var_current_temperature := var_min_temperature;
  10. for var_index in var_min_temperature..var_max_temperature loop
  11. begin
  12. raise notice 'var_current_temperature %', var_current_temperature;
  13. var_current_temperature := var_current_temperature + var_step;
  14. end;
  15. end loop;
  16. end $$;