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
this leads imho to inconsistencies later, if tests with = ANY or similar are
done.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
