Re: idea: allow AS label inside ROW constructor

On Thu, Oct 23, 2014 at 4:34 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> Hi
>
> here is a prototype
>
> postgres=# select row_to_json(row(10 as A, row(30 as c, 20 AS B) as x));
>          row_to_json
> ------------------------------
>  {"a":10,"x":{"c":30,"b":20}}
> (1 row)
>
> postgres=# select row_to_json(row(10, row(30, 20)));
>            row_to_json
> ----------------------------------
>  {"f1":10,"f2":{"f1":30,"f2":20}}
> (1 row)

wow -- this is great.   I'll take a a look.

merlin