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