Re: Function with DEFAULT arguments - Mailing list pgsql-general

From Tom Lane
Subject Re: Function with DEFAULT arguments
Date
Msg-id 10999.1268412700@sss.pgh.pa.us
Whole thread Raw
In response to Function with DEFAULT arguments  ("dario.ber@libero.it" <dario.ber@libero.it>)
Responses Re: Function with DEFAULT arguments  (Scott Bailey <artacus@comcast.net>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: "dario.ber@libero.it"
Date:
Subject: R: Re: Function with DEFAULT arguments
Next
From: Scott Bailey
Date:
Subject: Re: Function with DEFAULT arguments