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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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