Re: BUG #14426: union causes error

On 11/16/2016 03:25 PM, abo(at)zetescards(dot)be wrote:
> The following bug has been logged on the website:
>
> Bug reference: 14426
> Logged by: Alain Bourgeois
> Email address: abo(at)zetescards(dot)be
> PostgreSQL version: 9.6.1
> Operating system: Linux
> Description:
>
> select null union select null union select 1
>
> causes an error.

First of all, it is standard practice to say what the error is.

This is not a bug, but a known limitation. In your first query, your
column is of type "unknown", but when you union it with another unknown
type, it gets turned into text. Unioning text with integer is what is
giving you your error.

The solution is to make sure you type your data, at least in the first
query.
--
Vik Fearing +33 6 46 75 15 36
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support