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" <[email protected]> wrote: > Gourav Kumar <[email protected]> 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 >
