On Tue, 15 Nov 2011 16:38:20 -0700
"J.V." <jvsrvcs@xxxxxxxxx> wrote:
> How do I drop a function that was created like so:
>
> create or replace function process_table (action TEXT,
> v_table_name varchar(100)) RETURNS BOOLEAN
> AS $$
> DECLARE
> ....
> BEGIN
> ...
> END;
> $$ LANGUAGE plpgsql;
>
> ---
> I have tried various ways, but it always fails.
>
>
> J.V.
>
test=# begin;
create or replace function process_table (
action TEXT, v_table_name varchar(100)
) RETURNS BOOLEAN
AS $$
DECLARE
BEGIN
return true;
END;
$$ LANGUAGE plpgsql;
drop function process_table (
action TEXT, v_table_name varchar(100)
);
commit;
BEGIN
CREATE FUNCTION
DROP FUNCTION
COMMIT
test=#
Repeat just the input parameters.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
