Tom Lane wrote:
> "dario(dot)ber(at)libero(dot)it" <dario(dot)ber(at)libero(dot)it> writes:
>> I'm trying to use the DEFAULT option to pass parameters to the arguments of a
>> function.
>> When I call that function, how can I change the default value of some
>> arguments and leave as default the value of other arguments?
>
> You can only omit arguments from right to left, so basically what this
> requires is some foresight while choosing the function's argument order.
>
> regards, tom lane
>
What do you think about allowing 'default' as a parameter the way we do
when inserting a record?
So if a param has a default value, the function call may look like:
SELECT foo(default, 'hello', 43)
Scott Bailey