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)