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

pgsql: Make ARRAY(SELECT ...) return an empty array, rather than a NULL,

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Make ARRAY(SELECT ...) return an empty array, rather than a NULL,
Date: 2007-08-26 21:44:25
Message-ID: 20070826214425.A1ADB7541FB@cvs.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Make ARRAY(SELECT ...) return an empty array, rather than a NULL, when the
sub-select returns zero rows.  Per complaint from Jens Schicke.  Since this
is more in the nature of a definition change than a bug, not back-patched.

Modified Files:
--------------
    pgsql/src/backend/executor:
        nodeSubplan.c (r1.89 -> r1.90)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeSubplan.c?r1=1.89&r2=1.90)
    pgsql/src/backend/optimizer/plan:
        subselect.c (r1.123 -> r1.124)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/subselect.c?r1=1.123&r2=1.124)
    pgsql/src/include/nodes:
        primnodes.h (r1.132 -> r1.133)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/primnodes.h?r1=1.132&r2=1.133)

pgsql-committers by date

Next:From: Tom LaneDate: 2007-08-26 23:22:49
Subject: pgsql: Code review for btreefuncs additions: restrict to superusers to
Previous:From: Tom LaneDate: 2007-08-25 20:29:25
Subject: pgsql: Adjust with-system-tzdata patch to not attempt to install a

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