| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-08-26 23:22:49 | pgsql: Code review for btreefuncs additions: restrict to superusers to |
| Previous Message | Tom Lane | 2007-08-25 20:29:25 | pgsql: Adjust with-system-tzdata patch to not attempt to install a |