2008/12/14 Greg Stark <stark@enterprisedb.com>:
> On Sun, Dec 14, 2008 at 1:42 AM, Robert Haas <robertmhaas@gmail.com> wrote:
>>> What if relabeling support were to spread some more?
>>
>> The only example I can think of besides XML is JSON. There might be a
>> few more. Basically, relabelling is a handy shortcut when you are
>> serializing data and want to avoid specifying a list of columns and an
>> (almost) identical list of labels.
>
> The whole relabeling thing seems like a seriously silly idea. Why is
> it at all a shortcut to use "AS" instead of "," ? The relabeling adds
> zero actual expressiveness, it just makes a fancy way to pass an
> argument.
>
>
Because AS is signal for collecting column (or label) names.
I thing so we should use "AS" as Tom's proposal, together with SQL/XML
functionality.
It's only idea: default behave is using as for param name specification,
seconf with flag maybe labeled allows using AS in SQL/XML behave
But this syntax don't allow use this feature together (it is maybe enought).\
create function json(variadic labeled values int[]) ...
Pavel