Re: [HACKERS] Domains and arrays and composites, oh my - Mailing list pgsql-hackers

"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