Re: About functions

Hi,

On Sun, 24 Feb 2002, Stephan Szabo wrote:

>
> You can't use the argument as a parameter directly in that sql statement.
> You might be able to do:
> EXECUTE ''DROP FUNCTION '' || $1;

Thanks but, again an error:

test=# CREATE FUNCTION dropfunc(text) RETURNS integer AS '
test'# BEGIN;
test'# EXECUTE ''DROP FUNCTION'' $1;
test'# SELECT 1;
test'# END;
test'# '
test-# LANGUAGE SQL;
ERROR: parser: parse error at or near "EXECUTE"
test=#

Let me dive into my manuals :)

Regards

--

Devrim GUNDUZ

devrim(at)oper(dot)metu(dot)edu(dot)tr
devrim(dot)gunduz(at)linux(dot)org(dot)tr
devrimg(at)tr(dot)net

Web : http://devrim.oper.metu.edu.tr
------------------------------------------------------------------