BUG #1847: Error in some kind of UNION query. - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      1847
Logged by:          THIBAULT Jean-Jacques
Email address:      jjt4@wanadoo.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)