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 ;)
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
