Re: BUG #3543: ARRAY(SELECT ...) contruct yields NULL without rows - Mailing list pgsql-bugs

On Thu, Aug 16, 2007 at 11:11:49AM +0000, Jens Schicke wrote:
>=20
> The following bug has been logged online:
>=20
> Bug reference:      3543
> Logged by:          Jens Schicke
> Email address:      j.schicke@asco.de
> PostgreSQL version: 8.2.4
> Operating system:   GNU/Linux
> Description:        ARRAY(SELECT ...) contruct yields NULL without rows
> Details:=20
>=20
> SELECT ARRAY(SELECT 1 WHERE 1 =3D 0) IS NULL; -- true

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