Re: idea: allow AS label inside ROW constructor - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: idea: allow AS label inside ROW constructor
Date
Msg-id CAFj8pRA4rqJb91XKFnVy2H_A7+NFHQJNUOzJObJCwATaEM_u9w@mail.gmail.com
Whole thread Raw
In response to idea: allow AS label inside ROW constructor  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
same query I have in Czech postgres users mailing list

Pavel

2014-10-22 18:21 GMT+02:00 Pavel Stehule <pavel.stehule@gmail.com>:
Hi

with new functions row_to_json(b), there is more often usage of ROW constructor. Using names in fields is relative difficult. Because ROW has special clause in parser, I am thinking so we can enable labeling inside ROW constructor

so instead currently supported:

select row_to_json(r) from (select 10 as a, 20 as b) r;

users can to write:

select row_to_json(row(10 as a,20 as b));

labeling will be enabled "only" inside ROW constructor. I don't propose enable it everywhere.

What do you think about it?

Regards

Pavel

Currently supported syntax is natural for long time PostgreSQL user, but it is relative strange for usual user.


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: idea: allow AS label inside ROW constructor
Next
From: Merlin Moncure
Date:
Subject: Re: idea: allow AS label inside ROW constructor