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" <t...@sss.pgh.pa.us> wrote: > Gourav Kumar <gourav1...@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 >