Executing function dynamically

prdola

Hi,
I have a table with function names and some other flags where to run them. Sth like this table called PROCESS

Expand|Select|Wrap|Line Numbers

 name    run_daily   run_monthly

func1       Y                   N

func2       Y                   Y

func3       N                   Y

...

then I have function that should execute selected functions sth like

Expand|Select|Wrap|Line Numbers

 create or replace function execute_process() returns void as

$$

declare

  c_process refcursor; 

  r_process dwh_loader.process%ROWTYPE;

  v_stmt varchar(200);

begin

  OPEN c_process FOR SELECT * 

                       FROM process 

                      WHERE run_daily = 'Y';

  LOOP

    fetch c_process into r_process;

    -- 

    IF  NOT FOUND THEN

        EXIT;  -- exit loop

    END IF;    

    v_stmt := 'perform '|| r_process.name ||';';

    --

    execute v_stmt;

  END LOOP;

  --

  return;

end;

$$language plpgsql;

This is pretty much how I would handle this situation in Oracle, but Postgre does not allow
execute 'perform....'

Any suggestion how to resolve this issue?

Karel

prdola

Suggestion is to use

execute 'command string' into variable;

like here
http://www.postgresql.org/docs/8.3/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN

Executing function dynamically

re: Executing function dynamically

Similar PostgreSQL Database bytes

/bytes/development

/bytes/it

/bytes/about