About functions

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?

Regards and best wishes,


Devrim GUNDUZ

devrim@oper.metu.edu.tr
devrim.gunduz@linux.org.tr
devrimg@tr.net

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