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
Date: Thu, 13 Jul 2017 15:42:48 -0400
Message-ID: <15150.1499974968@sss.pgh.pa.us> (raw)
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: tgl@sss.pgh.pa.us, david.g.johnston@gmail.com
Subject: Re: Domains and arrays and composites, oh my
In-Reply-To: <15150.1499974968@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox