About functions

From: Devrim GUNDUZ <devrim(at)oper(dot)metu(dot)edu(dot)tr>
To: PostgreSQL Mailing Lists-General <pgsql-general(at)postgresql(dot)org>
Subject: About functions
Date: 2002-02-24 19:59:33
Message-ID: Pine.LNX.4.44.0202242154250.7909-100000@oper.metu.edu.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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(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
------------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2002-02-24 21:28:56 tcpip_socket vs -i
Previous Message Hugo Coolens 2002-02-24 17:19:12 no database files found.