Re: WIP: default values for function parameters - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: WIP: default values for function parameters
Date
Msg-id 493E6EFC.7070302@gmx.net
Whole thread Raw
In response to Re: WIP: default values for function parameters  (Decibel! <decibel@decibel.org>)
List pgsql-hackers
Decibel! wrote:
> On Nov 30, 2008, at 12:04 PM, David E. Wheeler wrote:
>> Agreed, default values should not be a part of function signatures, 
>> although it might be nice if ALTER FUNCTION to allow default values to 
>> be changed.

> It would be VERY nice. I routinely cut and paste an entire function 
> header to later perform things like ALTER and GRANT so that I don't have 
> to re-type everything. It would be a huge PITA if I had to then go and 
> delete any default settings.

That is not what David was talking about above.

Currently, I don't think you can change parameter default values of an 
existing function.  But I think that would be a useful and 
uncontroversial addition.


pgsql-hackers by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: WIP: default values for function parameters
Next
From: Peter Eisentraut
Date:
Subject: Re: WIP: default values for function parameters