PL/pgSQL function syntax question?

Поиск
Список
Период
Сортировка
От Ruben Gouveia
Тема PL/pgSQL function syntax question?
Дата
Msg-id 51e507b0809081440h2bd96f56md842410e80103965@mail.gmail.com
обсуждение исходный текст
Ответы Re: PL/pgSQL function syntax question?
Список pgsql-sql
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


В списке pgsql-sql по дате отправления: