Merlin Moncure <mmoncure@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
