"David G. Johnston" <david.g.johns...@gmail.com> writes:
> On Thursday, July 13, 2017, Tom Lane <t...@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
