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: 20050825085326.D204FF0B25@svr2.postgresql.org (view raw or flat)
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.
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)

Responses

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-2014 The PostgreSQL Global Development Group