On Tue, May 31, 2011 at 5:01 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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.
>> 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.
In response to
pgsql-general by date
|Next:||From: Craig Ringer||Date: 2011-06-01 00:08:13|
|Subject: Re: UTC4115FATAL: the database system is in recovery mode|
|Previous:||From: Tom Lane||Date: 2011-05-31 22:01:19|
|Subject: Re: Function Column Expansion Causes Inserts To Fail |