Re: Expression to construct a anonymous record with named columns?

On Fri, Sep 21, 2012 at 4:18 AM, Benedikt Grundmann
<benedikt.grundmann@gmail.com> wrote:
>
> On 21 September 2012 07:50, Alban Hertroys <haramrae@gmail.com> wrote:
>>
>> 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 rationale or 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);
>>
> Thank you very much.  This is very interesting. However this again seems
> to be strangely limited, because I can neither extract a column from row
> that was constructed this way in a scalar position nor expand it:
>
> proddb_testing=# select (select x from (values (1, 2, 3)) x (a, b, c));
>  ?column?
> ----------
>  (1,2,3)
> (1 row)

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

:-)

merlin