Tom Lane wrote:
"[email protected]" <[email protected]> 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
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
