Re: Function with DEFAULT arguments

Tom Lane wrote:
> "dario.ber@libero.it" <dario.ber@libero.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