=> SELECT NULL UNION ALL SELECT 1;
(2 rows)
=> SELECT NULL UNION ALL SELECT NULL UNION ALL SELECT 1;
ERROR: UNION types text and integer cannot be matched
=> SELECT pg_typeof(t.t) FROM (SELECT NULL AS t UNION ALL SELECT NULL AS t) t;
text
text
нул юнион нул у него текст
вывод типов уровня постгреса
http://www.postgresql.org/docs/9.4/static/typeconv-union-case.html
If all inputs are of type unknown, resolve as type text (the preferred type of the string category). Otherwise, unknown inputs are ignored.
#GQPAQM/78H
/ @pxqr
/ 3443 дня назад
Цоперайт © 2010-2016 @stiletto.