Re: Function with DEFAULT arguments

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "dario(dot)ber(at)libero(dot)it" <dario(dot)ber(at)libero(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Function with DEFAULT arguments
Date: 2010-03-12 16:51:40
Message-ID: 10999.1268412700@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Bailey 2010-03-12 17:07:43 Re: Function with DEFAULT arguments
Previous Message dario.ber@libero.it 2010-03-12 16:50:22 R: Re: Function with DEFAULT arguments