Horton

Re: Domains and arrays and composites, oh my

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
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>
Date: 2017-07-13T19:42:48Z
Lists: 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

Commits

  1. Support domains over composite types in PL/Perl.

  2. Support domains over composite types in PL/Tcl.

  3. Support domains over composite types.

  4. Fix multiple assignments to a column of a domain type.