Re: WIP: default values for function parameters

Pavel Stehule wrote:
> 2008/12/10 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>:
> > 2008/12/10 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> >> "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> writes:
> >>> next argument - if we accept AS for param names, then we introduce
> >>> nonconsistent behave with SQL/XML functions.
> >>
> >>> select xmlforest(c1, c2 as foo, c3) -- there foo isn't doesn't mean
> >>> "use it as param foo",
> >>
> >> It could be read as meaning that, I think.
> >>
> >> In any case, I'm not wedded to using AS for this, and am happy to
> >> consider other suggestions.
>
> what do you thing about?
>
> select fce(p1,p2,p3, SET paramname1 = val, paramname2 = val)
>
> example
> select dosome(10,20,30, SET flaga = true, flagb = false)

I think AS read more naturally because you expect the parameter to come
first, not the SET keyword.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +