Re: create function : change name of input parameter - Mailing list pgsql-general

Lori Corbani <Lori.Corbani@jax.org> writes:
> My example:

> DROP FUNCTION ACC_setMax();

> CREATE OR REPLACE FUNCTION ACC_setMax (
> increment int,
> prefixPart varchar(30) = 'MGI:'
> )
> RETURNS VOID AS
> \$\$

This is not the right thing: you need to include the parameters in the
drop command.  ACC_setMax() is a totally different function from
ACC_setMax(int, varchar).

            regards, tom lane