"Hou, Zhijie" <houzj(dot)fnst(at)cn(dot)fujitsu(dot)com> 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
think you're going to get any exciting results that way though ...
as create_plan() notes, the exact spot where an initplan is attached
to the tree isn't terribly relevant.
regards, tom lane