Re: Expression to construct a anonymous record with named columns? - Mailing list pgsql-general

On 20 Sep 2012, at 20:36, Benedikt Grundmann wrote:

> So named anonymous records / row types seem to be strangely second class.  Can somebody clarify the restrictions and
rationaleor even better show a way to do the equivalent of (made up syntax ahead): 
>
> select row(1 as a, 2 as b);

select * from (values (1, 2, 3)) a (a, b, c);

Alban Hertroys

--
Screwing up is an excellent way to attach something to the ceiling.