BUG #1453: NULLs in UNION query

From: "" <m(dot)woehling(at)barthauer(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1453: NULLs in UNION query
Date: 2005-01-31 23:55:16
Message-ID: 20050131235516.22DF19A5812@www.postgresql.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1453
Logged by:
Email address: m(dot)woehling(at)barthauer(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-02-01 03:45:08 Re: [Feed-back] Installing PostgreSQL 8.0.0 on SPARC/Solaris. Configure and install issues.
Previous Message Dave Page 2005-01-31 21:21:56 Re: Template1 is locked when pgAdminIII is open