Re: create function : change name of input parameter

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lori Corbani <Lori(dot)Corbani(at)jax(dot)org>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: create function : change name of input parameter
Date: 2014-08-20 14:21:12
Message-ID: 9422.1408544472@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Lori Corbani <Lori(dot)Corbani(at)jax(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jov 2014-08-20 14:53:19 Linux replication to FreeBSD problem
Previous Message Rob Sargent 2014-08-20 14:15:08 Re: create function : change name of input parameter