Merlin Moncure <mmoncure(at)gmail(dot)com> writes:
> I've never taken the time to really get my head around 'lateral'
> enough to say for sure if it provides clean workarounds for all the
> cases that get people into hot water. The case that used to get me a
> lot is (the unfortunately generally under utilized) custom aggregates.
> problem:
> select bar_id, (some_agg(foo)).* from foo join bar ... group by bar_id;
Hm, really? I'd expect that nodeAgg's attempts to collect identical
aggregate calls into one would keep you out of trouble there. That
hack unfortunately doesn't generalize to ordinary functions ...
regards, tom lane