From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
cc: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Subject: Re: Domains and arrays and composites, oh my
In-reply-to: 
 <CAKFQuwYohbi4-bAU=PwPR1m=U4vicy_hRDqbXPj7QyWd6+oKiA@mail.gmail.com>
References: <4206.1499798337@sss.pgh.pa.us> <12364.1499973554@sss.pgh.pa.us>
 <CAKFQuwYohbi4-bAU=PwPR1m=U4vicy_hRDqbXPj7QyWd6+oKiA@mail.gmail.com>
Comments: In-reply-to "David G. Johnston" <david.g.johnston@gmail.com>
	message dated "Thu, 13 Jul 2017 12:36:30 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <15149.1499974968.1@sss.pgh.pa.us>
Date: Thu, 13 Jul 2017 15:42:48 -0400
Message-ID: <15150.1499974968@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Thursday, July 13, 2017, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> regression=# select * from fdc();
>> fdc
>> -------
>> (1,2)
>> (1 row)

> Select (fdc).* from fdc();  is considerably more intuitive that the cast.
> Does that give the expected multi-column result?

Yeah, it does, although I'm not sure how intuitive it is that the
parentheses are significant ...

regression=#  select * from fdc();
  fdc  
-------
 (1,2)
(1 row)

regression=# select fdc from fdc();
  fdc  
-------
 (1,2)
(1 row)

regression=# select fdc.* from fdc();
  fdc  
-------
 (1,2)
(1 row)

regression=# select (fdc).* from fdc();
 r | i 
---+---
 1 | 2
(1 row)

			regards, tom lane


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers