On Tue, May 31, 2011 at 5:01 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Merlin Moncure <mmonc...@gmail.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 ...
you appear to be right -- memory failing here. merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
