The following bug has been logged online: Bug reference: 1453 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0 Operating system: Windows 2000 Description: NULLs in UNION query Details:
The following query should not raise an error ("ERROR: UNION types text and integer cannot be matched"): SELECT NULL AS Test UNION ALL SELECT NULL UNION ALL SELECT 0 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly