]> granicus.if.org Git - postgresql/commit
Re-allow SRFs and window functions within sub-selects within aggregates.
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 27 Jun 2017 21:51:11 +0000 (17:51 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 27 Jun 2017 21:51:11 +0000 (17:51 -0400)
commit3a7bd59c4496b5b9a7cec9ab6f1eb6b111a8b046
treecfc9c5f373f3495024d6ad4524181475c15dae5d
parentdf31a9fc66f11e824872dc09d22f389cbd5bc803
Re-allow SRFs and window functions within sub-selects within aggregates.

check_agg_arguments_walker threw an error upon seeing a SRF or window
function, but that is too aggressive: if the function is within a
sub-select then it's perfectly fine.  I broke the SRF case in commit
0436f6bde by copying the logic for window functions ... but that was
broken too, and had been since commit eaccfded9.

Repair both cases in HEAD, and the window function case back to 9.3.
9.2 gets this right.
src/backend/parser/parse_agg.c