"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 jo
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?
>
>
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
---
Hash Join (cost=13.15..26.48 rows
