Greg Stark writes:
> I do note that the code in question was added in this commit in 2010.
> That predates the addition of LATERAL in 2013.
Yeah. It's pretty clear from the comments that I was concerned about
false matches of PARAM_EXEC numbers. I think that was a live issue
at the time but is
So I guess I don't have much to add since I don't really understand
the Param infrastructure, certainly not any better than you seem to.
I do note that the code in question was added in this commit in 2010.
That predates the addition of LATERAL in 2013. I suppose those
comments may be talking
On Fri, Sep 16, 2022 at 5:59 PM Richard Guo wrote:
> I'm not saying this is a bug, but just curious why param 0 cannot be
> displayed as the referenced expression. And I find the reason is that in
> function find_param_referent(), we have the 'in_same_plan_level' flag
> controlling that if we
I have a question about displaying NestLoopParam. In the plan below,
# explain (costs off)
select * from a, lateral (select sum(i) as i from b where exists (select
sum(c.i) from c where c.j = a.j and c.i = b.i) ) ss where a.i = ss.i;
QUERY PLAN
