Postgres Pro
Downloads
Home   >   mailing lists

BUG #1453: NULLs in UNION query - Mailing list pgsql-bugs

From
Subject BUG #1453: NULLs in UNION query
Date
Msg-id 20050131235516.22DF19A5812@www.postgresql.com
Whole thread Raw
Responses Re: BUG #1453: NULLs in UNION query  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      1453
Logged by:
Email address:      m.woehling@barthauer.de
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

pgsql-bugs by date:

Previous
From: Heiko Nocon
Date:
Subject: Re: BUG #1443: Can't start service of Postgres
Next
From: "Jonathan Chen"
Date:
Subject: BUG #1452: psql and other programs don't offer a password prompt, so I can't login to databases