Re: unintuitive subquery record wrapping

On 18.9.2010 4:31, Tom Lane wrote:
> Rikard Pavelic <rikard(dot)pavelic(at)zg(dot)htnet(dot)hr> writes:
>
>> For basic query:
>> select t from t
>> result is of type t.
>>
> yeah ...
>
>
>> If I query:
>> select sq from (select t from t) sq;
>> result is of type record.
>>
> yeah ... it's a record containing a single field of type t.
>
> regards, tom lane
>
>
That was unhelpful ;(

You removed the important part of question ;)
I'll try again...

I'm arguing that is seems wrong that I need to match alias name like this
select t from (select t from t) t
or like this
select sq from (select sq from t sq) sq
to get unwrapped type.

Maybe I'm alone arguing this because nobody writes queries like that :)

Regards,
Rikard