[guillermoariast]

Hi, i would like to return a numeric data from this function. I want to modify the nature of the function by a parameter.

see line:
sql:= ' res:= select (4+5.2)';

This is where i would like to modify by parameter


CREATE OR REPLACE FUNCTION modelo.test2()
RETURNS numeric AS
$BODY$
declare
res numeric; sql text;
begin
sql:= ' res:= select (4+5.2)';
execute sql;
return res;
end;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;


This function does not work. ¿Why?.
I receive comments or solutions.
Thanks

[loquin]

I don't understand. You want to pass parameters to the function? So that it sums the two numbers, and returns the result?

[amthomas]

yeah.. I am not sure either.

you should post the error you get too.

as a side note, I don't believe you need to use volatile on this function since you aren't really doing anything to tables.

[loquin]

By the way - Have you installed pl/pgsql? (using a CREATE LANGUAGE statement?) It doesn't come installed by default, even though you selected it during an install. That only makes it AVAILABLE to install.

ref http://www.postgresql.org/docs/8.2/s...g-install.html

[shammat]

Originally Posted by loquin

It doesn't come installed by default, even though you selected it during an install. That only makes it AVAILABLE to install.

At least on windows this is not true. After installer was finished I could use the installed languages right away.

[loquin]

Actually, I had to, on a windows install. That was on v8.1 POSSIBLY, that is not the case on v8.2. When I upgraded to 8.2, I didn't have to reinstall the language, but, I thought that the language the language got carried along as a part of the upgrade process.