"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