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@gmx.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