i get the following error when i try and create the following function:
Basically, i am trying to have two different dates compared and only the most recent returned to me. This seems pretty straight forward, what I am doing wrong here?
create or replace function fcn_pick_date(v_dt date)
returns date as $$
DECLARE
v_dt date;
BEGIN
for v_record in select last_periodic, last_boot
from mediaportal
loop
if v_dt >= v_record.last_boot then
v_dt := v_record.last_periodic;
else
v_dt := v_record.last_boot;
end if;
end loop;
return (v_dt);
END;
$$ LANGUAGE 'plpgsql';
ERROR: loop variable of loop over rows must be record or row variable at or near "loop" at character 195
********** Error **********
ERROR: loop variable of loop over rows must be record or row variable at or near "loop"
SQL state: 42601
Character: 195
