Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group