Re: proposal sql: labeled function params

On Fri, 2008-08-15 at 14:54 +0200, Pavel Stehule wrote:
> 2008/8/15 Peter Eisentraut <peter_e(at)gmx(dot)net>:
> > Am Thursday, 14. August 2008 schrieb Pavel Stehule:
> >> I propose enhance current syntax that allows to specify label for any
> >> function parameter:
> >>
> >> fcename(expr [as label], ...)
> >> fcename(colname, ...)
> >>
> >> I would to allow same behave of custom functions like xmlforest function:
> >> postgres=# select xmlforest(a) from foo;
> >> xmlforest
> >> -----------
> >> <a>10</a>
> >> (1 row)
> >
> > Do you have a use case for this outside of XML?
> >
>
> JSON and similar (custom) protocols

why not use a format string, or any other separate (sub)language ?

select json('[name:$1, age: $2]', name, age) from students;

------------
Hannu