Re: unintuitive subquery record wrapping - Mailing list pgsql-general

From Tom Lane
Subject Re: unintuitive subquery record wrapping
Date
Msg-id 2007.1284777079@sss.pgh.pa.us
Whole thread Raw
In response to unintuitive subquery record wrapping  (Rikard Pavelic <rikard.pavelic@zg.htnet.hr>)
Responses Re: unintuitive subquery record wrapping  (Rikard Pavelic <rikard.pavelic@zg.htnet.hr>)
List pgsql-general
Rikard Pavelic <rikard.pavelic@zg.htnet.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

pgsql-general by date:

Previous
From: Rikard Pavelic
Date:
Subject: unintuitive subquery record wrapping
Next
From: Rikard Pavelic
Date:
Subject: Re: unintuitive subquery record wrapping