After completing a residential construction program, students. Is there a place for theory in industrial HVAC?Q:
How to use a for loop in a postgresql function?
I am trying to create a for loop in a function in postgresql.
But I am getting an error : "ERROR: syntax error at or near "for"."
This is my function :
create or replace function store_air_conditions(day as date, name_of_day as varchar,
temp_f as double precision,
hum_f as double precision,
hum_ideal as double precision,
hum_des as double precision,
hum_avg as double precision,
air_vel_high as double precision,
air_vel_low as double precision,
C1 as double precision,
C2 as double precision,
C3 as double precision,
C4 as double precision,
e_m as double precision,
e_d as double precision,
e_m1 as double precision,
e_d1 as double precision)
returns double precision as $$
BEGIN
CREATE TABLE IF NOT EXISTS new_air (
id bigint DEFAULT nextval('new_air_id_seq'::regclass) NOT NULL PRIMARY KEY,
date_n_gen as date,
name_of_day as varchar,
temp as double precision,
hum as double precision,
hum_ideal as double precision,
hum_des as double precision,
hum_avg as double precision,
air_vel as double precision,
air_vel_high as double precision,
air_vel_low as double precision,
C1 as double precision,
C2 as double precision,
C3 as double precision,
C4 as double precision,
e_m as double precision,
e_d as double precision,
e_m1 as double precision,
e_d1 as double precision);
for date in '2019-01-01' '2019-02-01' be359ba680
Related links:
Comments