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: [EMAIL PROTECTED] > 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 [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
pgpKS5QumAiA6.pgp
Description: PGP signature
