Well for this given query it is possible. I haven't come across any such query yet.
Possibly because I am more concerned about the TPCDS and TPCH benchmarks, where it's less likely to occur. On 13 October 2017 at 00:52, Tom Lane <t...@sss.pgh.pa.us> wrote: > Gourav Kumar <gourav1...@gmail.com> writes: > > A Join clause/predicate will only mention 2 relations. It can't have 3 or > > more relations. > > Really? What of, say, > > select ... from a,b,c where (a.x + b.y) = c.z; > > regards, tom lane > -- Thanks, Gourav Kumar Computer Science and Automation Indian Institute of Science
