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. Branch ------ REL9_5_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/9a2706572351d168af05216892a1f02a02c1a54f Modified Files -------------- src/backend/parser/parse_agg.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers