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

BUG #3543: ARRAY(SELECT ...) contruct yields NULL without rows

From: "Jens Schicke" <j(dot)schicke(at)asco(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3543: ARRAY(SELECT ...) contruct yields NULL without rows
Date: 2007-08-16 11:11:49
Message-ID: 200708161111.l7GBBnso007837@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      3543
Logged by:          Jens Schicke
Email address:      j(dot)schicke(at)asco(dot)de
PostgreSQL version: 8.2.4
Operating system:   GNU/Linux
Description:        ARRAY(SELECT ...) contruct yields NULL without rows
Details: 

SELECT ARRAY(SELECT 1 WHERE 1 = 0) IS NULL; -- true

this leads imho to inconsistencies later, if tests with = ANY or similar are
done.

Responses

pgsql-bugs by date

Next:From: Heikki LinnakangasDate: 2007-08-16 11:41:23
Subject: Re: BUG #3542: Dropped and recreated columns have problems with NOT NULL contraints
Previous:From: Jens SchickeDate: 2007-08-16 10:39:44
Subject: BUG #3542: Dropped and recreated columns have problems with NOT NULL contraints

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