Re: how to drop function?

On Tue, 15 Nov 2011 16:38:20 -0700
"J.V." <jvsrvcs@gmail.com> 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