I've also come across this in 7.4. You could also use:
SELECT NULL AS Test
UNION ALL SELECT NULL::int
UNION ALL SELECT 0
Dirk
Tom Lane wrote:
"" <[EMAIL PROTECTED]> writes:
The following query should not raise an error ("ERROR: UNION types text and
integer cannot be matched"):
SELECT
"" <[EMAIL PROTECTED]> writes:
> 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
Hmm ... it works if you do
SELECT NULL AS Test
UNION ALL (SELECT NULL
UNION ALL SELECT
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: UNIO
