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

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

From: Decibel! <decibel(at)decibel(dot)org>
To: Jens Schicke <j(dot)schicke(at)asco(dot)de>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3543: ARRAY(SELECT ...) contruct yields NULL without rows
Date: 2007-08-16 14:09:11
Message-ID: 20070816140910.GA54309@nasby.net (view raw or flat)
Thread:
Lists: pgsql-bugs
On Thu, Aug 16, 2007 at 11:11:49AM +0000, Jens Schicke wrote:
> 
> 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

And just what would you have it return? An array with no elements is by
definition NULL.
-- 
Decibel!, aka Jim Nasby                        decibel(at)decibel(dot)org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2007-08-16 15:00:21
Subject: Re: BUG #3543: ARRAY(SELECT ...) contruct yields NULL without rows
Previous:From: Heikki LinnakangasDate: 2007-08-16 11:41:23
Subject: Re: BUG #3542: Dropped and recreated columns have problems with NOT NULL contraints

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