From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Doc: add example of type resolution in nested UNIONs. |
Date: | 2018-03-25 20:15:34 |
Message-ID: | E1f0C3C-0002en-3V@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Doc: add example of type resolution in nested UNIONs.
Section 10.5 didn't say explicitly that multiple UNIONs are resolved
pairwise. Since the resolution algorithm is described as taking any
number of inputs, readers might well think that a query like
"select x union select y union select z" would be resolved by
considering x, y, and z in one resolution step. But that's not what
happens (and I think that behavior is per SQL spec). Add an example
clarifying this point.
Per bug #15129 from Philippe Beaudoin.
Discussion: https://postgr.es/m/152196085023.32649.9916472370480121694@wrigleys.postgresql.org
Branch
------
REL9_3_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/b666c55b2caee0e0c1f9afc404dd00f79c98bc3d
Modified Files
--------------
doc/src/sgml/typeconv.sgml | 29 +++++++++++++++++++++++++++++
1 file changed, 29 insertions(+)
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2018-03-26 12:10:13 | pgsql: Optimize btree insertions for common case of increasing values |
Previous Message | David Steele | 2018-03-25 19:59:22 | Re: pgsql: Exclude unlogged tables from base backups |