From: | Hannu Krosing <hannu(at)2ndQuadrant(dot)com> |
---|---|
To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: proposal sql: labeled function params |
Date: | 2008-08-15 19:24:44 |
Message-ID: | 1218828284.7387.17.camel@huvostro |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-08-15 21:54:00 | Re: Mini improvement: statement_cost_limit |
Previous Message | Bruce Momjian | 2008-08-15 18:25:56 | Re: Automatic Client Failover |