add parameter to existing function

From: Peter Kroon <plakroon(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: add parameter to existing function
Date: 2013-12-10 14:26:24
Message-ID: CAOh+DOm=3yqvi=Hge70b7OeDu=Cf1-NZe6nTVPwDu_8rEPRYSg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Best,
Peter

Responses

Browse pgsql-general by date

  From Date Subject
Next Message misspaola 2013-12-10 14:53:13 DB Audit
Previous Message Greg Sabino Mullane 2013-12-10 14:00:35 Re: PG replication across DataCenters (section 25 in the manual)