calling functions which are stored as values in a table

[ravysters]

hi... i have this problem... consider the following code... create or replace function sam(in j int) returns int
as
$$
declare
i int;
begin
i := 4;
i= i*j;
return i;
end;
$$
language plpgsql;

create table sam1
(
i varchar
)
insert into sam1 values('sam(j)');


how can i call the function sam which is in the table sam1.. please help

[rski]

you can create a plpgsql function

create or replace function execute2(varchar) returns integer as $$
declare
i integer;
begin
        execute $1 into i;
        return i;
end;
$$ language 'plpgsql';
 

and use it

select execute2('select '||i) from sam1;
 

[ravysters]

i am still getting this error...

column "j" does not exist
LINE 1: select sam(j)

[rski]

i am still getting this error...

column "j" does not exist
LINE 1: select sam(j)

you wrote

create table sam1
(
i varchar
)
 

you should use 'i' not 'j'.