I don't think there is any need to add any such capability in postgresql, but I need it for my work.
I need the join qualifiers.
On 15-Oct-2017 1:37 AM, "Tom Lane" <
tgl@sss.pgh.pa.us> wrote:
Gourav Kumar <gourav1905@gmail.com> writes:
> Is there some way by which I can tell postgresql to not to consider
> transitive joins while considering join pairs.
No ... and you have presented no reason whatever why we should consider
adding such a capability.
Maybe you should be trying to construct your join graph someplace
earlier, before the optimizer processes the join quals.
regards, tom lane