Re: About functions

On Sun, 24 Feb 2002, Devrim GUNDUZ wrote:

>
> Hi,
>
> While working on functions, I had a problem:
>
> I wanted to write a function whict would drop my function. It is simply as
> below:
>
>
>     CREATE FUNCTION dropfunc(text) RETURNS integer AS '
>             DROP FUNCTION $1 ;
>             SELECT 1;
>     '
>     LANGUAGE SQL;
>
>
> But PostgreSQL answers:
>
> test=# ERROR:  parser: parse error at or near "$1"
>
>
> What is the error in here?

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

(Note also that the above requires arguments of the form
foo(int) not just foo).