Re: how to drop function?

Ivan Sergio Borgonovo, 16.11.2011 01:01:
> 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.

You don't have to include the parameter names though

    drop function process_table (TEXT, varchar(100));

is just as good and bit less typing ;)