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

From: Alban Hertroys <haramrae(at)gmail(dot)com>
To: Benedikt Grundmann <benedikt(dot)grundmann(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Expression to construct a anonymous record with named columns?
Date: 2012-09-21 06:50:48
Message-ID: FBB23506-2391-44A9-8F2F-4A151272549B@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 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);

Alban Hertroys

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2012-09-21 07:01:45 Re: Using psql -f to load a UTF8 file
Previous Message Chris Angelico 2012-09-21 05:30:00 Re: Using psql -f to load a UTF8 file