Skip site navigation (1) Skip section navigation (2)

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

From: "THIBAULT Jean-Jacques" <jjt4(at)wanadoo(dot)fr>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1847: Error in some kind of UNION query.
Date: 2005-08-25 08:53:26
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs
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.

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. 


Jean-Jacques THIBAULT (France)


pgsql-bugs by date

Next:From: Michael FuhrDate: 2005-08-25 14:09:12
Subject: Re: BUG #1847: Error in some kind of UNION query.
Previous:From: Tom LaneDate: 2005-08-25 04:18:47
Subject: Re: Ref: BUG#1321: SSL error: sslv3 alert handshake failure

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group