Re: Initplan placed at the righttree or the lefttree of joinnode

2020-10-22 Thread Tom Lane
"Hou, Zhijie" writes: > Can Initplan placed at the righttree or the lefttree of joinnode? Initplans generally get attached to the topmost node of a given (sub)query, cf create_plan(). You might be able to get what you want by having an unflattenable subquery as one input of a join. I do not thi

Re: Initplan placed at the righttree or the lefttree of joinnode

2020-10-22 Thread Laurenz Albe
On Thu, 2020-10-22 at 09:43 +, Hou, Zhijie wrote: > Hi, > > I try to make some special query plan like the following. > I have tried a lot SQL, but failed. > Can Initplan placed at the righttree or the lefttree of joinnode? > > (Fake) QUERY PLAN > --