title: Passing parameters to EXECUTE in plpgsql function
body: <p>I get following error from the function below:</p>
  
  <pre><code>ERROR:  column "_df" does not exist  
  
  create or replace function lax()returns setof record as
  $$
  declare 
    rs record;
    _planunitcode int;
    _DF VARCHAR(25);
    str text;
  begin
    _planunitcode:=1;
    _DF :='role.planner';
    str :='select role from userplanunit where role = _DF';
    --str :='select role from userplanunit where role = quote_literal('DF');';quote_ident
    for rs in execute str
    --for rs in select role from userplanunit where role = _DF
    loop
      return next rs;
    end loop;
    return;
  end
  $$ language 'plpgsql';
  </code></pre>