Re: BUG #1847: Error in some kind of UNION query.

THIBAULT Jean-Jacques wrote:
> The following bug has been logged online:
>
> Bug reference: 1847
> Logged by: THIBAULT Jean-Jacques
> Email address: jjt4(at)wanadoo(dot)fr
> PostgreSQL version: 8.0.3
> Operating system: Linux (Mandrake)
> Description: Error in some kind of UNION query.
> Details:
>
> this query work :
> select null UNION 1;
>
> this query doesn't work :
> select null UNION null UNION 1;
>
> ERROR: UNION types text and integer cannot be matched

You probably mean
SELECT NULL
UNION
SELECT NULL
UNION
SELECT 1

Proper casting will help, insuring the correct type can be determined
from the first SELECT. Changing the order to have SELECT 1 does the job too.

Regards,
Andreas