Re: Domains and arrays and composites, oh my

"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> On Thursday, July 13, 2017, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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