Re: [GENERAL] add parameter to existing function

2013-12-10 Thread Merlin Moncure
On Tue, Dec 10, 2013 at 8:26 AM, Peter Kroon wrote: > Hi, > > I can use: create or replace function etc > to alter a function. > > However, this will create a new function instead of replacing the old one > when adding a parameter. > Is this possible without the use of DROP and CASCADE? nope!

[GENERAL] add parameter to existing function

2013-12-10 Thread Peter Kroon
Hi, I can use: create or replace function etc to alter a function. However, this will create a new function instead of replacing the old one when adding a parameter. Is this possible without the use of DROP and CASCADE? The function that I'm trying to alter is on some tables a default value.