Re: proposal sql: labeled function params - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: proposal sql: labeled function params
Date
Msg-id 162867790808150554obc5b85dpd1c52dd497e911ee@mail.gmail.com
Whole thread Raw
In response to Re: proposal sql: labeled function params  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: proposal sql: labeled function params  (Hannu Krosing <hannu@2ndQuadrant.com>)
List pgsql-hackers
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

Pavel


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: XML / XSL rendering in PostgreSQL server?
Next
From: Peter Eisentraut
Date:
Subject: varchar/name casts