pgsql: Doc: add example of type resolution in nested UNIONs.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Doc: add example of type resolution in nested UNIONs.
Дата
Msg-id E1f0C3C-0002ei-3J@gemulon.postgresql.org
обсуждение исходный текст
Список 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_6_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/356f85f95cb0b0e99ce51932c2a9dbd292f0b292

Modified Files
--------------
doc/src/sgml/typeconv.sgml | 29 +++++++++++++++++++++++++++++
1 file changed, 29 insertions(+)


В списке pgsql-committers по дате отправления:

Предыдущее
От: David Steele
Дата:
Сообщение: Re: pgsql: Exclude unlogged tables from base backups
Следующее
От: Andrew Dunstan
Дата:
Сообщение: pgsql: Optimize btree insertions for common case of increasing values