The following bug has been logged online: Bug reference: 1847 Logged by: THIBAULT Jean-Jacques Email address: [EMAIL PROTECTED] 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) ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings