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

From David E. Wheeler
Subject Re: WIP: default values for function parameters
Date
Msg-id 9405E2FD-CB0D-4369-A36F-63970E4E8173@kineticode.com
Whole thread Raw
In response to Re: WIP: default values for function parameters  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: WIP: default values for function parameters
List pgsql-hackers
On Nov 30, 2008, at 6:49 PM, Tom Lane wrote:

> Peter Eisentraut <peter_e@gmx.net> writes:
>> There are two ways to fix this, both having some validity:
>
>> 1. We create a second version of pg_get_function_arguments() that  
>> produces
>> arguments without default values decoration.  This is probably the
>> technically sound thing to do.
>
> Yes.  I think that the argument for allowing parameter names in  
> commands
> like ALTER FUNCTION is that the user might consider them part of the
> function's identity.  This can hardly be claimed for default values.

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.

Best,

David


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: WIP: default values for function parameters
Next
From: "David Rowley"
Date:
Subject: Re: Windowing Function Patch Review -> Standard Conformance