Re: About functions - Mailing list pgsql-general

From Devrim GUNDUZ
Subject Re: About functions
Date
Msg-id Pine.LNX.4.44.0202251049320.11548-100000@oper.metu.edu.tr
Whole thread Raw
In response to Re: About functions  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
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@oper.metu.edu.tr
devrim.gunduz@linux.org.tr
devrimg@tr.net

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




pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: About functions
Next
From: TPCCUVA
Date:
Subject: Embedded SQL: foreign keys.