On Tue, Mar 23, 2010 at 12:40 AM, Hitoshi Harada <umi.tanuki@gmail.com> wrote:
> I believe the changes will probably not be 2-3 lines (ie. a member
> added to Query structure, etc) if I try it. But the optimizer part is
> too complicated to me so that I am not sure, either. My idea above is
> that the similar mechanism you see in GROUP BY optimization will help
Are you suggesting that the windowing clause should perhaps refer to a
column in the target list, much like GROUP BY/ORDER BY, so that one
can easily see if the qual in the fromexpr corresponds to the
windowClause to see if the pushdown is safe?
fdr