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

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

I use Hibernate API, that generates this kind of query in "one table for
each concret class" mapping strategy. I allways have real value in a union
member that justify this kind of query.

Thank-you.

Jean-Jacques THIBAULT (France)